A constraint that prevents a specified column's values from being duplicated within a table.
A constraint that can prohibit duplicate values even on columns other than the primary key, also called a UNIQUE constraint. In most RDBMSes, adding a unique constraint automatically creates an index for it too, giving you faster duplicate-checking as a side benefit.
© 2026 ITBGM