List Indexes with Include Columns

Question

List Indexes with Include Columns

JohnnyDBA

SSCertifiable

Points: 6355
More actions
October 16, 2009 at 10:27 am

#215586

Is there a built in procedure that lists indexes along with their include columns in SQL 2005?
The only way I know how to see the include columns is by joining sys.indexes to sys.index_columns.
I'm just looking for something like an sp_help that lists the indexes but also the include columns.
Thanks,
John

Viewing 2 posts - 1 through 1 (of 1 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Not built in, but Kimberly Tripp wrote one.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/sp_helpindex2-to-show-included-columns-%2820052b%29-and-filtered-indexes-%282008%29-which-are-not-shown-by-sp_helpindex.aspx

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Updates-%28fixes%29-to-sp_helpindex2.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass