How can we check that table have index or not?

Asked 2010-04-29T08:59:55.727

How can we check that table have index or not ? if have how to find that index for a particular column for a table?

Regards, kumar

sql sql-server sql-server-2005 sql-server-2008

Edit Report

1 Answer

-1

Try

select object_name(object_id),* from sys.indexes 
where object_name(object_id) = 'your table name'

answered 2010-04-29T09:04:52.150