.MDF File Sizes
Posted on 2004-04-15
I have a database that was roughly 230 GB large. I deleted all tables in the database and the .mdf file was still 230 GB large. Does the delete from table, truncate from table, and/or the drop table commands not physically remove the data from the .mdf file? I ended up detaching the database and deleting it to regain the space but I am concerned over the implications that this could have on other databases that I have. Any advise would be appreciated.