Constraint Not Showing Under "Constraints" in Management Studio

I created a new table like this:

IF OBJECT_ID('MyTables') IS NULL
CREATE TABLE MyTables (
id INT IDENTITY (1,1),
SomeName VARCHAR(20) NOT NULL CONSTRAINT UniqueSomeName UNIQUE (SomeName)
);

Now, when I got to Management Studio (2005), the constraint does not show under the "Constraints", but it does show under the "Indexes" and "Statistics". Am I doing something wrong?
LVL 9
GivenRandyAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
a UNIQUE constraint is implemented by a UNIQUE INDEX. hence it shows up there...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Am I doing something wrong?
no
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Check for that one in indexes
0
 
GivenRandyAuthor Commented:
LMAO -- Of course. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.