Hello,

I recently deleted some columns from a table with the statement DROP and I saw that database size doesn't change, it remains exactly the same(very big by the way). So I suposse DROP only take away the logical references but the COLUMN is still physically there. The question is: How do I do to release this space from the database?

Thanks in advance

Nacho

if you want to reclaim Database wide space then you have option of using DBCC SHRINKDATABASE or DBCC SHRINKFILE

Thank you for the answer, anyway those comands are just for "compact"database and they actually don't give back the space lost in the drop proccess. The way I founded, for you to know, is
DBCC UPDATEUSAGE(0)
This command recalculates lost space
Nacho

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.