SQL Server Transact Basic to Expert - Add Unique Constraints to Existing Table

SQL Server Transact Basic to Expert - Add Unique Constraints to Existing Table

This blog shows how to add UNIQUE constraint to the existing table.

Syntax:

Alter table tablename
Add contraint(ConstraintName)
Unique(ColumnName)

Example:

Alter table emptable
Add Constraint(Unq_emptable_empsalary)
Unique(empsalary)