Friday, February 24, 2012

List of al lindexes and their properties for a db

sp_helpindex gives information for a single table. Is there a way of getting the same information for all user tables in a database?You may want to use the sys.indexes catalog view.

No comments:

Post a Comment