Dropping a Check Constraint

Drop a check constraint to remove an existing condition limiting data inserts.

Prerequisites 

Before you can drop a check constraint, be sure the data server on which you are dropping a check 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 check constraint.
  2. Expand the Check Constraints folder, and find the check constraint you want to drop.
  3. Right-click the check constraint, and choose Drop.
Related concepts
Check Constraints
Related tasks
Creating a Check Constraint
Editing a Check 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.