Thursday, June 10, 2010

How to View All Indexes in a Table

Through below simple Stored Procedure which it can display the name of Indexes and the columns on which indexes are created.

USE AdventureWorks;
GO
EXEC sp_helpindex 'HumanResources.Employee'
GO 

Above Stored Procedure will return following information.

A new and improved sp_helpindex. sp_helpindex sql server 2005. sp_helpindex sql server. sp_helpindex sql server 2008. sp_helpindex sybase. use sp_helpindex sql. sql sp_helpindex example. sp_helpindex permissions. How do you execute the sp_helpindex system stored procedure. Stored procedure to view index information. Should I call sp_helpindex for each table and store the results in a temp table. Modified sp_helpindex SP to show all indexes for all tables. in sql server 2012. in sql server 2008 R2. in sql server 2005.

0 comments:

Post a Comment