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
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'
Output
Output
Syntax
EXEC sp_helpindex 'Dbo.Table_Name'
Example
EXEC sp_helpindex 'Dbo.Employee_Info'
Output
Output
Join the conversation! Your thoughts help the community grow.