SQL Reference

Unique Keys

A unique key is a key that is constrained so that no two of its values are equal. The columns of a unique key cannot contain null values. The constraint is enforced by the database manager during the execution of any operation that changes data values, such as INSERT or UPDATE. The mechanism used to enforce the constraint is called a unique index. Thus, every unique key is a key of a unique index. Such an index is also said to have the UNIQUE attribute. See Unique Constraints for a more detailed description.


[ Top of Page | Previous Page | Next Page ]