Purpose
You can use this statement to rewrite the data of a table.
Syntax
ALTER TABLE table_name SHRINK SPACE;
Parameters
| Parameter | Description |
|---|---|
| table_name | The name of the table. |
Examples
Rewrite the data of the tbl1 table.
obclient> ALTER TABLE tbl1 SHRINK SPACE;
Query OK, 0 rows affected