DBCC CLEANTABLE

Reclaim space from dropped variable-length columns in a table or indexed view.

Syntax
      DBCC CLEANTABLE
       ( { 'database' | database_id | 0 }
         , { 'table' | table_id | 'view' | view_id }
            [ , batch_size]
       ) [WITH NO_INFOMSGS]

 Key:
    batch_size   - The no. of rows to process per transaction.
                    default (or if 0 is specified) = whole table
    NO_INFOMSGS  - Suppress all information messages.

If 0 is specified, the current database will be used.

Example

DBCC CLEANTABLE ('MyDatabase','MySchema.MyTable', 0)
WITH NO_INFOMSGS;
GO

"It's hard to be funny when you have to be clean" ~ Mae West.

Equivalent Oracle command:

ALTER TABLESPACE COALESCE


© Copyright SS64.com 1999-2014
Some rights reserved