sp_helpindex to show included columns - by AThurgar

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


22
0
Sign in
to vote
ID 577526 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 7/22/2010 4:43:48 PM
Access Restriction Public

Description

We were unable to drop a column in a table because it was used in an index on the table.
sp_helpindex did not show this column as it was an included column on the index.
It would have been a lot easier if sp_helpindex showed the index included columns
Sign in to post a comment.
Posted by Kenneth Fisher on 8/10/2016 at 3:13 PM
Am I confused or are you saying that you are closing this because there is a free third party script that will work around it? Has sp_helpindex been deprecated since it doesn't return accurate information anymore?
Posted by Microsoft on 5/17/2011 at 12:34 PM
After consideration of this feature request and our current priority list of features, we decided to not provide this support as there is an existing workaround already available with at par capabilities. Thanks for your suggestion.

Best regards
Microsoft SQL Server Engine Team
Posted by Mohammed [MSFT] on 10/19/2010 at 5:31 PM
Hello Adam,

Thank you for your feedback. A DCR (Design Change Request) has been submitted for this request and we will look into improving sp_helpindex for our next release.

In the meantime, there is an alternate way of getting the information you seek through querying multiple system views (e.g. sys.objects, sys.indexes, sys.index_columns, etc.). You can find an example of this on Kimberly Tripp’s Blog here: http://www.sqlskills.com/blogs/Kimberly/post/Updates-(fixes)-to-sp_helpindex2.aspx

Thanks,
Mohammed