Added a unique index, but cannot find it in TABLE_CONSTRAINTS I'm running the following command in my DB:

CREATE UNIQUE INDEX [UK_NAME1] ON [TABLE1] ([COLUMN1] ASC);


Now, I'm running the following query:

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS


And yet I can't find my unique index listed in there.

Am I using the wrong query? What other issue could there be?
Use this syntax, which also allows you to name the constraint:

ALTER TABLE Persons ADD CONSTRAINT UQ_PersonID UNIQUE (P_Id,LastName)