More things like SP_HELPTEXT

I used SP_HELPTEXT to return stored procedure scripts...

Is there a way in which I can quickly return INDEX definition scripts?
Mr_ShawAsked:
Who is Participating?
 
rushShahConnect With a Mentor Commented:
try this.


EXEC sp_helpindex 'tableName'

Open in new window

0
 
rushShahConnect With a Mentor Commented:
for ex.


USE AdventureWorks;
GO
EXEC sp_helpindex 'Person.Contact'
GO

Open in new window

0
 
Mr_ShawAuthor Commented:
thanks..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.