Listing all indexes within a database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Listing all indexes within a database

Author

Topic

bogey
Posting Yak Master

166 Posts

Posted - 2007-05-23 : 16:06:49

Working with sql server 2005. Is there a way through Management Studio to show all indexes within a db?

thanks.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-05-23 : 16:08:41

Have you checked sys.indexes?

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

rudesyle
Posting Yak Master

110 Posts

Posted - 2007-05-24 : 09:48:12

quote:
Originally posted by dinakar

Have you checked sys.indexes?

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

select * from sys.indexes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources