You can create and drop UNIQUE constraints for columns in Sybase Central.
Prerequisites
DBA authority.
Context and remarks
Spatial columns cannot be included in a UNIQUE constraint.
For a column, a UNIQUE constraint specifies that the values in the column must be unique. For a table, the UNIQUE constraint identifies one or more columns that identify unique rows in the table. No two rows in the table can have the same values in all the named column(s). A table can have more than one UNIQUE constraint.
Manage unique constraints (Sybase Central)Use the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, double-click Tables.
Click the table you want to alter.
In the right pane, click the Constraints tab.
Right-click in the Constraints tab and click New » Unique Constraint.
Complete the instructions in the Create Unique Constraint Wizard.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |