List of Indexes on a Table

To list all the indexes on a table use:

exec sp_helpindex table_name

where table_name is the name of the table for which the list of indexes are required.
This lists the index name, the type (e.g. clustered, non clustered, unique etc) and which columns the index is created on. Further details can be found by consulting the SQL server documentation.

Reference : http://www.cryer.co.uk/brian/sqlserver/sqlsvrhowto.htm

|