OneData 10.7 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Managing Object Constraints | Creating Unique Constraints
 
Creating Unique Constraints
You can create a unique constraint to ensure that a column contains no duplicate values. If you are using SQL Server, you can create multiple unique constraints on the same column.
Note:
Once a unique constraint is created, you cannot modify it to make it Case Insensitive.
*To create a unique constraint
1. On the Menu toolbar, click Define > Objects and select the object in which you want to create unique constraint.
2. Click Structure tab.
3. Click Edit Constraints.
4. Click Add new Unique constraint and complete these fields:
Property
Description
Constraint Name
Enter a name for the constraint.
Customized Error Message
An error message to show up when this constraint is violated.
Case Insensitive?
Whether to allow duplicate values with different cases. For example, if the option is checked, both “Test” and “TEST” cannot be inserted. If the box is not selected, both “Test” and “TEST” are allowed.
Note:
If you are using SQL Server, you cannot configure the unique constraint to check for case sensitivity.
Available Columns
All the columns in the object that can be used to build the constraint.
Selected Columns
The columns already selected to build the constraint.
5. Click Save.