Constraints MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Constraints
  4. 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 ] )