list of indexes

Question

list of indexes

bala2

SSCertifiable

Points: 5547
More actions
June 2, 2010 at 7:45 pm

#222308

i want to display the list of indexes of all the tables in db?
plz any one help me?
thankyou

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ben Teraberry SSChampion Points: 11845 More actions · Answer 1

Check out sys.indexes and sys.objects in Books Online. However, if you are on a developed system, you will probably be overwhelmed by a list of all indexes on all tables in a database. If you want to look at information about indexes on a particular table you can also use sp_helpindex.

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 2

SELECT [TableName] = st.name,

[IndexName] = si.name

FROM sys.tables st

JOIN sys.indexes si

ON si.object_id = st.object_id

WHERE st.is_ms_shipped = 0

ORDER BY st.name, si.name

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

bala2 SSCertifiable Points: 5547 More actions · Answer 3

bala2

SSCertifiable

Points: 5547

June 2, 2010 at 9:25 pm

#1175671

thankyou

can you plz tell same using coursors?

WayneS SSC Guru Points: 95460 More actions · Answer 4

vijay82 (6/2/2010)
thankyou
can you plz tell same using coursors?

Sorry, I don't do c.u.r.s.o.r.s.

(See??? I can't even type it!) :w00t:

..... what's wrong with the query? Why do you feel a cursor is necessary?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 5

ColdCoffee

SSC-Dedicated

Points: 39972

June 2, 2010 at 11:09 pm

#1175695

~Edit: Wrong code at wrong place :sick: