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,

Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/