how to get the index definition of a give table of a MS SQL database?

I need to know how to list the index name (and their attribute) on a given table of a SQL databases.

show index?    which table name to assign?

thanks
mshox1Asked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Commented:
exec sp_helpindex MyTableName
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.