CODEWITHSUNDEEP
sql-serversql-server-2008indexingcovering-index
IamIC
IamIC

Reputation: 18269

CREATE INDEX in SQL Server 2008 not result in "visible index"

I am using SQL Server 2008 Express. In the DB in question, there is only one schema: dbo.

If I run the following script:

CREATE UNIQUE INDEX IX_ClientSocialTypes_Cover
ON ClientSocialTypes(ClientID, SocialTypeClassID, [Source]) INCLUDE (URLID);

... it executes ok, but I cannot see the index when I go into DB Diagram and view the indexes for this table. Further, the "Includes" field is always grayed out, even when I specify non-clustered index (hence my use of a script).

Any ideas?

Upvotes: 0

Views: 6247

Answers (2)

Mutation Person
Mutation Person

Reputation: 30520

Do you see it when you run this query?:

select * 
from sys.indexes
where object_name(object_id) = 'ClientSocialTypes'

Upvotes: 0

marc_s
marc_s

Reputation: 755321

Where are you trying to see the index? Did you refresh the database diagram after creating the index?

Update: ok, it seems that in the diagram editor, you cannot define included columns (always grayed out - even in full SSMS, on SQL Server 2008 R2 Dev Edition).

But in the table designer (right-click on (your table name) > Indexes > New Index in Object Explorer),

alt text

it's totally visible and usable....

alt text

Upvotes: 2

Related Questions