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:)
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: