How can I get a simple breakdown of the size of my database in terms of GB/MB per table?

Is there a simple sql command that can be run? or is there an easy way to do this through the GUI?

I wish to delete from some of the larger tables in my DB, but I can find out which ones those are at the moment. I know if I right click the DB name and then go to properties I get the overall size, but how do I see size of each table?

If you are in SSMS then you can select the columns to viewn in "Object Explorer Details" which include "Data Space Used (KB)" and "Size (MB)".Right click on the header (where "Name" is) and you can select the column to view.

If you are in SSMS then you can select the columns to viewn in "Object Explorer Details" which include "Data Space Used (KB)" and "Size (MB)".Right click on the header (where "Name" is) and you can select the column to view.

djj

You should also include Index Space Used and Row Count. I have this setup and it is very useful for getting a quick look at this data. You can also used the standard report 'Disk Usage by Table' which you can get to by right-clicking the database and selecting reports.