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?