Jim Metcalf
asked on
size of tables in a sql database
Does anyone have a query that can tell me the size of individual tables within one sql database.
if not size in actual data size, maybe rows? would rather have size in megabytes though
if not size in actual data size, maybe rows? would rather have size in megabytes though
ASKER
shoot-
unfortunately. i am almost out of drive space because of this db and wouldnt be able to run that query
any other suggestion?
unfortunately. i am almost out of drive space because of this db and wouldnt be able to run that query
any other suggestion?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can also open the 'Object Explorer Details' in SSMS
Top Level of Object Explorer Details
From the Top-Level, open the Tables folder to get a list of all the tables in your database.
You may need to customise the columns to see the Space Used. This can be done by right clicking on the header row and choosing the columns you wish to display.
Top Level of Object Explorer Details
From the Top-Level, open the Tables folder to get a list of all the tables in your database.
You may need to customise the columns to see the Space Used. This can be done by right clicking on the header row and choosing the columns you wish to display.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys-
the report out of ssms worked just great
the report out of ssms worked just great
Open in new window