question

You can use sys.indexes or sysindexes

SELECT T.Name, I.name FROM sys.indexes I
INNER JOIN Sys.tables t
ON t.object_id = I.Object_ID
WHERE index_id >= 1 -- skip heep

This query will give you pretty much everything that sp_helpindex does - but better seeing as * It doesn't use a cursor like sp_helpindex does internally * It shows index keys and included columns as well Edit -> joined to `sys.objects` to ignore `is_ms_shipped` = 1 So... here's the code: SELECT QUOTENAME(OBJECT_SCHEMA_NAME([i].[object_id])) + '.' + QUOTENAME(OBJECT_NAME([i].[object_id])) AS [object_name], ISNULL(QUOTENAME([i].[name]), '**HEAP**') AS [index_name], CASE WHEN [i].[index_id] = 1 THEN 'clustered' ELSE 'nonclustered' END + CASE WHEN [i].[ignore_dup_key] 0 THEN ', ignore duplicate keys' ELSE '' END + CASE WHEN [i].[is_unique] 0 THEN ', unique' ELSE '' END + CASE WHEN [i].[is_hypothetical] 0 THEN ', hypothetical' ELSE '' END + CASE WHEN [i].[is_primary_key] 0 THEN ', primary key' ELSE '' END + CASE WHEN [i].[is_unique_constraint] 0 THEN ', unique key' ELSE '' END + ' located on ' + [ds].[name] AS [index_description], stuff((SELECT ',' + [c].[name] FROM [sys].[index_columns] AS [ic] INNER JOIN [sys].[columns] AS [c] ON [c].[column_id] = [ic].[column_id] AND [c].[object_id] = [ic].[object_id] WHERE [ic].[index_id] = [i].[index_id] AND [ic].[object_id] = [i].[object_id] AND [key_ordinal] > 0 ORDER BY [ic].[index_column_id] FOR XML PATH ('')), 1, 1, '') AS keys, stuff((SELECT ',' + [c].[name] FROM [sys].[index_columns] AS [ic] INNER JOIN [sys].[columns] AS [c] ON [c].[column_id] = [ic].[column_id] AND [c].[object_id] = [ic].[object_id] WHERE [ic].[index_id] = [i].[index_id] AND [ic].[object_id] = [i].[object_id] AND [key_ordinal] = 0 ORDER BY [ic].[index_column_id] FOR XML PATH ('')), 1, 1, '') AS includes FROM [sys].[indexes] AS [i] INNER JOIN [sys].[data_spaces] AS [ds] ON [ds].[data_space_id] = [i].[data_space_id] INNER JOIN [sys].[objects] [o] ON [o].[object_id] = [i].[object_id] WHERE [o].[is_ms_shipped] = 0

Its not pretty but you could use EXEC [sys].[sp_MSforeachtable] @command1 = N'EXEC sp_helpindex ''?'''