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. |