TSQL to get clustered index information in SQL Server 2005

Recently within a supportal case with CSS we have been given the following TSQL to get information on indexes, where I have modified a bit to get 'Clustered' index information alone that was helpful to see which tables lack of clustered index alone. declare @tablename sysname ; Set @tablename = '&lt;TableName&gt;' ; @tablename sysname ; Set @tablename = '&lt;TableName' ; with cte ( index_name , column_name , index_type ) as ( cte ( index_name , column_name , index_type ) as ( select i . name , c...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/03/10/3741.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3741" width="1" height="1">