<div>
select <br />
&nbsp; quotename(schema_name(o.sc<wbr />hema_id)) + '.' + quotename(o.name) as [object],<br />
&nbsp; i.name as [index],<br />
&nbsp; i.type_desc as [index type]<br />
from sys.indexes i<br />
inner join sys.objects o<br />
on i.[object_id] = o.[object_id]<br />
where i.name is not null<br />
order by [object], i.index_id
</div>


select
  quotename(schema_name(o.schema_id)) + '.' + quotename(o.name) as [object],
  i.name as [index],
  i.type_desc as [index type]
from sys.indexes i
inner join sys.objects o
on i.[object_id] = o.[object_id]
where i.name is not null
order by [object], i.index_id

<div>
<div class="content wysiwyg-content">
Is there a way to get a list of all indexes in all tables. &nbsp;Also identify if they are non-clustered or clustered. &nbsp;Using SQL 2005?
</div>
</div>


Is there a way to get a list of all indexes in all tables.  Also identify if they are non-clustered or clustered.  Using SQL 2005?

Find Indexes

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.