Skip to content

Check all SQL table size

With this simple query, you can find size of all tables on sql database

EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?'”

otherwise if you need to check a single table

you can use the following query

exec sp_spaceused tablename;