List All Indexes in SQL

Use this SQL script to improve performance and List all Indexes within a database.

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;

We're available if you need assistance implementing custom SQL code. Contact us for help!