Dropping a Unique Constraint

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.

  1. Expand the Tables folder and then expand the table that contains the unique constraint.
  2. Expand the Unique Constraints folder, and find the unique constraint you want to drop.
  3. Right-click the unique constraint, and choose Drop.
Related concepts
Unique Constraints
Related tasks
Creating a Unique Constraint
Editing a Unique Constraint

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.