Creating a Unique Constraint

Use a unique constraint to ensure that no two rows have the same values in the columns of the constraint.

1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
   • User Tables
   • Proxy Tables
3. Select the table for the unique constraint.
4. Select Properties.
5. Select Index > Unique Constraint.
   You see the Add Unique Constraint wizard.
6. Specify a name, then select Unique constraint.
7. (Optional) Click Make supporting index clustered.
8. Select the columns to include in the unique constraint.
9. Select a segment on which to place the unique constraint.
10. (Optional) Specify a fill factor percentage.
11. (Optional) Specify the maximum number of rows per page for the index.
12. (Optional) Specify the ratio of empty pages to filled pages to provide for expansion.
13. (Optional) Click Summary to verify your selected options.