Constraints
SQL implements constraint functionality with a CHECK constraint statement. Basically, constraints restrict the data that can be stored in relations. To show the “Constraints” management form, select the “Constraints” tab in the “Table” management form:
![Constraints](dist/img/Help ERBuilder 7.0.4 to generate CHM final2_fichiers/image083.jpg)
Creating a new constraint
To create a new constraint:
- Select
in the “Constraints” management tab:
- To confirm adding the newly created constraint, click on
.
![add constraint](dist/img/Help ERBuilder 7.0.4 to generate CHM final2_fichiers/image084.jpg)
Available in: Standard, Professional and Enterprise Editions.