UNIQUE

This is a column integrity constraint.
Do not get this confused with the PRIMARY KEY constraint
There are important differences:
UNIQUE can exist with or without the PRIMARY KEY
UNIQUE does not automatically imply NOT NULL
UNIQUE can be applied to several columns in the same table



CREATE TABLE MyProducts 
(
CONSTRAINT constraint_name ProductID INTEGER UNIQUE (ProductID)



In SQL Server a unique index is created automatically



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext