Added a unique index, but cannot find it in TABLE_CONSTRAINTS

0 votes

2 answers

122 views

information-schema sql-server-compact index constraint

                          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?

Asked by Mugen (117 rep)

Feb 15, 2015, 06:40 AM
Last activity: Feb 15, 2015, 08:02 AM

Added a unique index, but cannot find it in TABLE_CONSTRAINTS

Related Questions