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.
- In the
Table Schema Editor, select the
Constraints tab for the table for which you
want to edit the check constraint.
- Expand the
Check Constraints folder under
Constraints in the directory tree, and
highlight the check constraint to edit.
The Details pane displays information about the check constraint.
-
Edit the check constraint settings in the
Details pane.
| Field |
Description |
|---|
| Name |
Enter a name for the check constraint in the text
field. |
| Definition |
In this field, alter 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. |
- Select
from the main menu in WorkSpace to save your settings
to the 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.