What happens when we drop a column on a SQL Server table? Where's my space?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

andre.quitta SSCommitted Points: 1921 More actions · Answer 1

SSCommitted

Points: 1921

April 26, 2024 at 8:15 pm

Thank you. I enjoyed the article very much.

0ol2t5902 Grasshopper Points: 11 More actions · Answer 2

Presumably, future inserts (after the column is dropped) won't consume use space for the deleted column, though?

Also, question, if a page is rewritten (e.g., due to a normal insert or update), is the space taken by a deleted column recycled then?