Information about the Indexes on a Table

This blog describes indexes on Table by using sp_helpindex.

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