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?