Find index associated with the table in SQL Server

 
  Below are some of the ways to identify the indexes available on a particular object.

sp_help VENKAT_TABLE (sp_help table_name)
 
Else, you can use system objects to identify the indexes available on the table. Below is the query to achieve the same,

select * from sys.indexes i inner join sys.objects o
on i.object_id=o.object_id and o.name ='VENKAT_TABLE'


Cheers,
Ebook Download
View all
Learn
View all