Find what table a specific index belongs to

Question

If I have the name of an index, what query can I use to find what table the index belongs to?

Answer 1

SELECT OBJECT_NAME(object_id) FROM sys.indexes WHERE name = '...'

Answer 2

try this:

Select object_Name(Id) IndexName,
  object_name(parent_Obj) Tablename
From SysObjects
Where Type In ('K', 'F')
order By object_name(parent_Obj), 
         object_Name(Id)