Using system stored procedure sp_helpindex, system catalog views like sys.indexes or sys.index_columns methods.
1. Find Indexes On A Table Using SP_HELPINDEX
sp_helpindex is a system stored procedure which lists the information of all the indexes on a table or view. This is the easiest method to find the indexes in a table. sp_helpindex returns the name of the index, description of the index and the name of the column on which the index was created.
EXEC sp_helpindex '[[[SCHEMA-NAME.TABLE-NAME]]]'
GO
1. Find Indexes On A Table Using SP_HELPINDEX
sp_helpindex is a system stored procedure which lists the information of all the indexes on a table or view. This is the easiest method to find the indexes in a table. sp_helpindex returns the name of the index, description of the index and the name of the column on which the index was created.
EXEC sp_helpindex '[[[SCHEMA-NAME.TABLE-NAME]]]'
GO
