Finding the Size of INDEX on ALL TABLE in the current Database in SQL SERVER

Finding the Size of  INDEX on ALL TABLE in the current Database in SQL SERVER

Gives the list of index in the specified database.

use Northwind

SELECT object_name(object_id) as TableName, *

FROM sys.indexes

 

-- Get the indexes from all the table in the current database

exec sp_msforeachtable "sp_spaceused '?'"

Thanks:)