SELECT DB_NAME() AS Database_Name , sc.name AS Schema_Name , o.name AS TABLE_NAME , i.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 i.name IS NOT NULL AND o.type = 'U' ORDER BY o.name, i.type