Check Constraint Tutorial
-
Add / Edit a Check Constraint
-
If Adding a new Check Constraint:
There are a number of methods to add a New Check Constraint to the Schema. Choose the one you are most comfortable with:
- Open Manage Check Constraints screen and click the "Add" button. See Manage Schema Objects Tutorial
-
Select "Insert -> Check Constraint" from the main menu.
-
Right Click the Schema and select "New -> Check Constraint" then choose "with Selected Table" to auto-fill the values with the last selected Table or choose "without Selected Table" for a blank Check Constraint.
- Edit the properties of the Table you want to constrain, select the 'Constraints' tab, select 'Check Constraints' and click the 'Add' button. See Edit Table Properties Tutorial
If Editing an existing Check Constraint:
There are a number of methods to edit an existing Check Constraint in the Schema. Choose the one you are most comfortable with:
- Open Manage Check Constraints screen and click the "Edit" button with the Constraint selected. See Manage Schema Objects Tutorial
- Edit the constrained Table's properties, select the 'Constraints' tab, select 'Check Constraints' and double click the Check Constraint. See Edit Table Properties Tutorial
- Editing Check Constraint Properties
-
If you are Adding a Check Constraint you can choose the Table you are constraining from the drop down list.
If you are editing this list will be locked.
- Setup the Check Constraint Name as required. See Object Names for more information.
-
Type the SQL that will constrain the selected Table
- Click the
button to Validate your SQL syntax. (Not Required) - There are a few keyboard shortcuts available for screens that allow direct SQL entry. See SQL Quick Tips
-
If you are Adding a Check Constraint you can choose the Table you are constraining from the drop down list.
If you are editing this list will be locked.
- Click OK to submit your changes.
- OR -
Click Cancel to discard your settings.
-
-
Delete a Check Constraint
There are a number of methods to delete a Check Constraint from the Schema. Choose the one you are most comfortable with:
- Open the Manage Check Constraints screen and click Delete with the Check Constraint selected. See Manage Schema Objects Tutorial
- Delete the Check Constraint's parent Table. See Delete Table Tutorial
- Edit the properties of the Parent Table, select the 'Constraints' tab, select 'Check Constraints', select the Check Constraint and click the 'Delete' button. See Edit Table Properties Tutorial
