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.
Syntax
DBCC CLEANTABLE ('MyDatabase', 'MyTable')
You can run this sql command from the SQL window in Teratrax Database Manager.
You need sysadmin or db_owner privileges to run DBCC CLEANTABLE.
|
