By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,943 Members | 1,890 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,943 IT Pros & Developers. It's quick & easy.

How to know the amount of megabites a table use have used?

P: 8

I'm revising my database right now and want to make a more compact database.

Therefore I want to know, whether it is possible to find out how much mega bites that each table used in my database.

so i can review and delete the big allocated tables.

Help me please hehehe :p

Best Regards
Oct 25 '06 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,471
I don't believe that data is available.

That's probably because it's not separated so neatly inside the DB.
Space is allocated dynamically to various tables in different orders.

You could look at the 'Compact and Repair Database...' option under Tools / Database Utilities.
Oct 25 '06 #2

Expert Mod 15k+
P: 31,471
I suppose if you really wanted to know you could :-

1. Create a new, empty DB and note its size on disk.
2. Import the table you're curious about into the new DB.
3. Check its size again and, with a little arithmetic, work out the difference.

This, by and large, should be a reflection of the size that this particular table takes up in the DB.
Oct 25 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.