List all indexes with size and table name – TSQL

select
object_name(i.object_id) as TableName,
i.name as IndexName,
i.index_id as IndexID,
8 * SUM(a.used_pages) as ‘Indexsize(KB)’
FROM sys.indexes as i
JOIN sys.partitions as p ON p.object_id = i.object_id and p.index_id = i.index_id
JOIN sys.allocation_units as a ON a.container_id = p.partition_id
where i.type_desc <> ‘heap’
Group by i.object_id,i.index_id,i.name
Order By object_name(i.object_id),i.index_id