Home Products Support Sales Corporate
Products
Performance Monitor
Database Compare
Database Manager
Job Scheduler






Home > Articles > SQL Server Administration > DBCC CLEANTABLE: Reclaim space for dropped columns

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.



Privacy Statement License Agreement Articles Site Map         Copyright © 2002-2008 Teratrax Inc. All rights reserved.