SQL Server sp_spaceused
SQL Server sp_spaceused is a SQL statement in the Administration category. SQL Server: reports disk space usage for a table or the entire database. The syntax is EXEC sp_spaceused ['table_name'];. It returns space usage report. A typical example: -- Database space: EXEC sp_spaceused; -- Returns: database_size, unallocated space -- Table space: EXEC sp_spaceused 'employees'; -- Returns: name, rows, reserved, data, index_size, unused -- All tables (using sp_msforeachtable): CREATE TABLE #space (name NVARCHAR(128), rows CHAR(11), reserved VARCHAR(18), data VARCHAR(18), index_size VARCHAR(18), unused VARCHAR(18)); INSERT #space EXEC sp_msforeachtable 'EXEC sp_spaceused "?"'; SELECT * FROM #space ORDER BY CAST(REPLACE(reserved, ' KB', '') AS INT) DESC; DROP TABLE #space; A close relative is CREATE USER, which creates a new database user account. A close relative is GRANT, which grants specific privileges (SELECT, INSERT, UPDATE, DELETE, ALL) to a user on a database/table. A close relative is REVOKE, which removes previously granted privileges from a user.