A check constraint is the most generic constraint type. It allows you to specify that the value in a certain column must satisfy a Boolean (truth-value) expression.

Checks are managed on the Checks tab of the Table Designer. Just simply click/double-click a check field for editing. Using the toolbar below, allowing you to create new, edit and delete the selected check field.

Add Check

To add a check

• Open the table in the Table Designer.
• Open the Checks tab.
• Right-click and select the Add Check from the popup menu or click the Add Check from the toolbar.
• Edit check properties.

Edit Check

To edit a check

• Open the table in the Table Designer.
• Open the Checks tab.
• Just simply click on the check to edit.

Delete Check

To delete a check

• Open the table in the Table Designer.
• Open the Checks tab.
• Right-click on the check to delete and select the Delete Check from the popup menu or click the Delete Check from the toolbar.
• Confirm deleting in the dialog window.

See also:
Setting Check Name and Expression