HOW TO: Obtaining the size of each table in an SQL database

In order to get a breakdown of the disk space usage by each table in your database:

1. Connect to SQL using SQL management Studio
2. Click "New Query"
3. Execute the following SQL query:

EXECsp_MSforeachtable@command1="EXEC sp_spaceused '?'"

  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

FAQ: Why is the design feature greyed out in Enterprise Manager?

The reason why you would not be able to use the design feature (greyed out), is because some...

FAQ: My database transaction log is too large

If your database is getting too large, it is most likely because of the transaction log file.If...

FAQ: What can I use to connect to my MS-SQL database?

You can use any third party MS-SQL client like:-SQL Server Management Studio express (microsoft...

PRB: Cannot connect to SQL 2008 or 2012 using Enterprise Manager

Enterprise Manager is not compatible with SQL 2008 or 2012 and will therefore not allow you to...

Powered by WHMCompleteSolution