unique key in ms sql server code example

Example: unique key in ms sql server

/* To create the Unique Key.
Unique Key constraint to enforce uniqueneess of a column i.e. the column 
shouldn't allow duplicate values.*/
ALTER TABLE Table_Name
ADD CONSTRAINT Constraint_Name UNIQUE (Column_Name)