You can create a check constraint as part of the table definition when you create a table. If a table already exists, you can add a CHECK constraint. Tables and columns can contain multiple check constraints. If a check constraint already exists, you can modify or delete it. For example, you may want to modify the expression that is used by the check constraint on a column in the table.
The following restrictions are actual for check constraints:
When the Table Editor is open, you can switch to the Constraints tab, and edit a constraint using the shortcut menu.
To delete a constraint, select a required one, and click Delete Constraint in the shortcut menu.
Consider you need to ensure that all employees in table Emp have and will have salary that is more than 500. This can be implemented best with check constraint. Open the table and create the constraint as described above. In the Condition type field - “Sal>500”, and save the document. At this moment all data in the table is checked for validity and, if it satisfies the condition, new constraint is applied to the table.
This example assumes you do not change some of constraint’s options which are located at the bottom of constraint editor. These options add some flexibility to constraints both in the moments of creation and altering. For example, you can: