Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2005

Tip: Looking for answers? Try searching our database.

drop table/recover space

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sue - 28 Jul 2005 17:47 GMT
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.
Phil Sherman - 29 Jul 2005 03:55 GMT
If you're using SMS then dropping the table deletes the underlying files
associated with it and frees up the disk space.

Phil Sherman

> 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
[quoted text clipped - 5 lines]
>
> Thank you very much for helping.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.