Finding the Size of INDEX on Specific TABLE in SQL SERVER

Finding the Size of  INDEX on Specific  TABLE in SQL SERVER

use Northwind

SELECT object_name(object_id) as TableName, *

FROM sys.indexes

 

--Syntax

exec sp_spaceused 'TableName'

 

-- Check the size of index

exec sp_spaceused 'Employees'

Thanks:)