Mega Code Archive

 

Categories / MSSQL Tutorial / Constraints

 

Adding a UNIQUE Constraint to an Existing Table

The syntax is as follows: ALTER TABLE table_name ADD CONSTRAINT  constraint_name UNIQUE  (column [ ASC | DESC ] [ ,...n ] )