Drop a unique table constraint to remove an existing uniqueness
requirement on non-null values in specified table columns.
PrerequisitesÂ
Before you can drop a unique constraint, be sure the data server on which you are dropping a unique constraint for a
table is running, and you created and established a
connection to the data server.
-
In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
Database |
Steps |
From an ASE connection profile |
- Expand the Databases folder.
- Expand the tree for a database
and then the tree for the appropriate schema owner.
|
From a SQL Anywhere or Sybase IQ connection profile |
- Expand the
tree for a database.
- Expand the
Schemas folder and then the tree for the appropriate schema owner.
|
-
Expand the
Tables folder and then expand the table that contains
the unique constraint.
-
Expand the
Unique Constraints folder, and find the unique
constraint you want to drop.
-
Right-click the
unique constraint, and choose
Drop.