DBCC CLEANTABLE: Reclaim space for dropped columns

DBCC CLEANTABLE reclaims table space after a column is dropped from the database using the ALTER TABLE DROP COLUMN statement. DBCC CLEANTABLE works for variable-length columns only. Variable-length columns are columns of type varchar, text, nvarchar, ntext, varbinary, and image.



DBCC CLEANTABLE ('MyDatabase', 'MyTable')
You need sysadmin or db_owner privileges to run DBCC CLEANTABLE.