EPUB | CHM | PDF

Constraints

Top Previous Next

Constraints give control over the data in your tables. If a user attempts to store data in a column that would violate a constraint, an error is raised. This applies even if the value came from the default value definition.

There are several types of constraints: check constraint, not null constraint, unique constraint, primary key constraint and foreign key constraint.

You can set a not null constraint and primary key constraint by using Column Editor. A check and unique constraint can be defined using Constraint Editor and Constraint Manager.

Please refer to References and Foreign Keys for information about a foreign key constraint.