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,