467,915 Members | 1,380 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

[Newbie Question] SSMS indexes

Under SSMS where can one find the list of indices?
I can see Stored procedures under Programmability. Is there any place
where I can see the list of indexes.
Apologies, if this is a stupid question.

--
VJ

Oct 3 '08 #1
  • viewed: 1376
Share:
2 Replies
Vogon Jeltz (sr****************@gmail.com) writes:
Under SSMS where can one find the list of indices?
I can see Stored procedures under Programmability. Is there any place
where I can see the list of indexes.
Apologies, if this is a stupid question.
In Object Explorer you can see the indexes only per table; there is no node
that lists indexes alone.

However, you could run this query to see all indexes in the database:

SELECT object_name(object_id), name
FROM sys.indexes
WHERE index_id 0


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Oct 3 '08 #2
Under SSMS where can one find the list of indices?

Indexes are dependent on a specific table so you need to first expand the
desired table node, where you will see an Indexes node. Note that SSMS will
include indexes that support constraints under the Indexes node too.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

Oct 3 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by inline_four | last post: by
2 posts views Thread by datapro01 | last post: by
3 posts views Thread by Larry Bertolini | last post: by
1 post views Thread by tlyczko | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.