DECLARE @TableID int
SELECT @TableID = OBJECT_ID ('Enter TableName here')
SELECT
OBJECT_NAME (IXStats.[object_id]) AS ObjectName,
IXStats.index_type_desc,
IXStats.avg_record_size_in_bytes
FROM
sys.dm_db_index_physical_stats (DB_ID(), @TableID, OBJECTPROPERTY (@TableID, 'TableHasClustIndex'), 0, 'SAMPLED') IXStats