Finding the Size of INDEX on Specific TABLE in SQL SERVER

How to find 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:)