047. Get all Clustered Indexes generated with primary keys only from Database – SQL Server Script

Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts
1
2
3
4
5
6
7
8
9
10
11
SELECT QUOTENAME(schema_name(t.schema_id))+ '.[' +t.name+']',
     i.name,i.*
    FROM sys.indexes i
    INNER JOIN sys.tables t
    ON t.object_id= i.object_id
    WHERE  i.type>0
    AND t.is_ms_shipped=0
    AND t.name<>'sysdiagrams'  --
    AND i.index_id=1
    AND i.is_unique=1
    AND i.type_desc='CLUSTERED'