This tab only appears for databases created with version 8.x and earlier of Adaptive Server Anywhere.
The Constraints tab of the Table property sheet has the following components:
Unique constraints list Lists each unique constraint defined for the table.
To create a new unique constraint for the table, click New. If you want to remove a unique constraint from the table, select the unique constraint from the list, then click Delete. You can select multiple unique constraints by holding Shift while you click.
New Displays the Create Unique Constraint dialog, which lets you create new unique constraints for columns of the table.
Delete Removes the unique constraint from the list.
Check constraint Lets you define conditions on a column or set of columns to make up the check constraint of the table. The check constraint restricts the values that can be entered in the column(s).
For example, to check that an employee's start date falls in a particular range, type:
CHECK ( start_date BETWEEN '1983/06/27'
AND CURRENT DATE )For more information, see .