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

drop table/recover space

P: n/a
Sue
Hi, is there anything I need to do to recover hard disk space after
deleting a table? I have a large table with blob fields and when I
first created the table I did not compact this field. So I am planning
to create a second table with this field compacted and then delete the
first table completely. I can "drop" this table from the control center
to delete the table, right? Then will this automatically free up space
or is there anything else that needs to be done?

Thank you very much for helping.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If you're using SMS then dropping the table deletes the underlying files
associated with it and frees up the disk space.

Phil Sherman
Sue wrote:
Hi, is there anything I need to do to recover hard disk space after
deleting a table? I have a large table with blob fields and when I
first created the table I did not compact this field. So I am planning
to create a second table with this field compacted and then delete the
first table completely. I can "drop" this table from the control center
to delete the table, right? Then will this automatically free up space
or is there anything else that needs to be done?

Thank you very much for helping.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.