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 '?'"