Query to check index on a table

Question

I want a query to see if a table already has any indexes on it.

Answer 1

This will display a list of all the indexes for the given table on SQL Server:

select * from sys.indexes
where object_id = (select object_id from sys.objects where name = 'MYTABLE')

This query will list all tables without an index:

SELECT name
FROM sys.tables 
WHERE OBJECTPROPERTY(object_id,'IsIndexed') = 0

I hope this helps you.