Answering Questions On Dropped Columns

Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...

Answering Questions On Dropped Columns

Answering a couple of questions from the previous posts about dropping columns.

Privacy Policy

We value your privacy. This policy explains what personal data we collect and why.
What We Collect

Cookies (for analytics, only after consent)
IP addresses (stored anonymously by our hosting provider)
Contact form...

Answering Questions On Dropped Columns

Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...

How much space can I expect to recover from a rebuild after dropping a column?

In my last article - Identify Tables With Dropped Columns - we saw how we can identify tables that have columns that were dropped. Today, we are going to...

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

You have dropped a column and wondering why you haven't recovered any space? Let's take a look.

Identify Tables With Dropped Columns

On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop...

How much Space can I expect to recover from a rebuild after dropping a column?

Check how much space you may expect to recover from a rebuild after dropping a column!

Identify Tables With Dropped Columns

How easily can we find tables with dropped columns that need cleanup?

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

This article was initially posted on SQLServerCentral @ 2024-04-26.
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable.
But, most importantly - The record/table size will remain...