SQL Server: UNIQUE Constraint Syntax 29. June 2009 Jon Blog (0) I always seem to be looking this up. So here it is: USE DatabaseName GO ALTER TABLE TableName ADD CONSTRAINT ConstraintName UNIQUE NONCLUSTERED (ColumnName) GO