Interviews Questions and Answers

1

Like

What is the system stored procedure that can be used to list all the indexes that are created for a specific table?


Posted by: James
On 25 Mar 2012 | Views: 879 | Categories: Database (SQL Server)
Interview Answers(1)

 On 25 Mar 2012 10:47:42 AM
sp_helpindex is the system stored procedure that can be used to list all the indexes that are created for a specific table.

For example, to list all the indexes on table tblProducts, you can use the following command.

EXEC sp_helpindex tblProducts

Post your Answers

 

Other lins

.Net Techies
Other lins