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
Jump to Postif you want to reclaim Database wide space then you have option of using DBCC SHRINKDATABASE or DBCC SHRINKFILE
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.