Monday, July 7, 2014

List all indexes in a table

exec sp_helpindex 'TABLE_NAME'  -- TABLE_NAME is a table name


No comments:

Post a Comment

Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists

If you received below error while attaching a .mdf file in cluster environment please follow below steps to resolve the issue ERROR Ca...