Information about the Indexes on a Table

sp_helpindex - It gives information about the indexes on a table or view.
 
 Syntax

 
 EXEC sp_helpindex 'Dbo.Table_Name'
 
 Example
 

 EXEC sp_helpindex 'Dbo.Employee_Info'
 
 Result Set displays

 Create Table with Primary Key
 
  
 Output


 Create Table with Candidate Key
 
 
 Output
 
 
 
Create a Table without Primary Key
 

 
  
 Output


Next Recommended Reading Delete Table Index in SQL Server