Editing a Check Constraint

Edit a check constraint to change a condition limiting data inserts for specified columns.

Prerequisites 

Before you can edit a check constraint, be sure that the data server containing the appropriate table is running, and you created and established a connection to the data server. Open the table containing the check constraint in the Table Schema Editor.

  1. In the Table Schema Editor, select the Constraints tab for the table for which you want to edit the check constraint.
  2. Expand the Check Constraints folder under Constraints in the directory tree, and highlight the check constraint to edit.
  3. Edit the check constraint settings in the Details pane.
    Field Description
    Name Enter a name for the check constraint.
    Definition Modify the Boolean expression for the check constraint. To add additional column names to this field, click Columns, select columns from the Columns dialog, and click OK.
  4. Select File > Save from the main menu.
Related concepts
Check Constraints
Related tasks
Creating a Check Constraint
Dropping a Check Constraint

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com