MSSQL NonClustured Indexleri Listeleme

SELECT DB_NAME() AS Database_Name, AS Schema_Name, AS Table_Name, AS Index_Name, i.type_desc AS Index_Type FROM sys.indexes i
INNER JOIN sys.objects o ON i.object_id = o.object_id
INNER JOIN sys.schemas sc ON o.schema_id = sc.schema_id
WHERE IS NOT NULL And i.type_desc =’NONCLUSTERED’ AND o.type = ‘U’ — o.type=’U’ Only get indexes for User Created Tables
ORDER BY, i.type