unique constraint


A kind of constraint that asserts that a column cannot contain any duplicate values. In terms of relational algebra, it is used to specify 1-to-1 relationships. For efficiency in checking whether a value can be inserted, (that is, the value does not already exist in the column), a unique constraint is supported by an underlying unique index.

See also constraint.

See also relational.

See also unique index.

Retornar