SELECT * FROM SYS.data
SELECT TBL.name [TABLE NAME],
SUM(AU.total_pages) *8 [AVAILABLE(IN KB)],
SUM(AU.used_pages) *8 [SPACE USED INCLUDING NULL(IN KB)],
SUM(AU.data_pages) *8 [SPACE USED EXCLUDING NULL(IN KB)]
FROM SYS.tables TBL
INNER JOIN SYS.indexes INDX ON TBL.object_id=INDX.object_id
INNER JOIN SYS.partitions PART ON INDX.index_id=PART.index_id AND TBL.object_id=PART.object_id
INNER JOIN SYS.allocation_units AU ON PART.partition_id=AU.container_id
GROUP BY TBL.name