I Want to view The Indexes on a Table by Query Analizer.

[yamcha]

Hi !!

I Need to view the Indexes on a Specific Table, is there a
Statement by Query Analyzer that can do this?

The only way that i know is by the Enterprise Manager,
accesing the "Tables & Indexes" Tab.
But i have more than 800 Tables, so it is too tired because
the locating is page by page.

If you have any idea please, let me know.
Thank You very much !!

 

[tlbroadbent]

You can use sp_helpindex. Do the following in Query Analyzer.

Use dbname
go

exec sp_helpindex "owner.tablename"
go

This will list all the indexes on the table giving the index name, description and key column(s).

 

[yamcha]

That's Right my Friend !!

I was using your instruction, and it work perfectly.

Thank you very much tlbroadbent !!

Juan Gallardo
MEXICO