Query to get tables having indexing in a particular database

Question

Can anyone provide me the query in sql server to extract the tables that have been done indexing, for a particular database....

Answer 1

Your question is somewhat unclear. This will return all tables with at least one index.

select DISTINCT OBJECT_NAME(object_id)  
from sys.indexes 
where type<>0

Or for SQL Server 2000

select DISTINCT OBJECT_NAME(id)   
from sysindexes 
where indid<>0