sys.sp_spaceused
general #stored-procedure
Description
Analytics Platform System (PDW) system stored procedure displays either: the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database the disk space reserved and used by the whole database For Azure Synapse Analytics and Analytics Platform System (PDW), upon the ordinal position of parameters.
Syntax
sp_spaceused (@objname= N'Table1');