Drop columns

This article introduces you to the supported conversion scope of the ALTER TABLE DDL column removal operation when migrating data from an Oracle database to OceanBase database in the Oracle compatible mode.

Syntax

drop_column_clause:
{ SET UNUSED { COLUMN column
             | (column [, column ]...)
             }
  [ { CASCADE CONSTRAINTS | INVALIDATE }... ]
  [ ONLINE ]
| DROP { COLUMN column
       | (column [, column ]...)
       }
  [ { CASCADE CONSTRAINTS | INVALIDATE }... ]
  [ CHECKPOINT integer ]
| DROP { UNUSED COLUMNS
       | COLUMNS CONTINUE
       }
  [ CHECKPOINT integer ]
}

Supported operations

Dropping one or more columns at a time is supported. Example:

ALTER TABLE T DROP COLUMN C;
ALTER TABLE T DROP (C1,C2);

Unsupported operations

• Dropping the SET UNUSED flag is not supported. An error will be returned when you perform this operation.

• Dropping all columns marked as unused from tables by using the DROP UNUSED COLUMNS clause is not supported. An error will be returned when you perform this operation.

• Resuming the column drop operation from the interrupted point by using the DROP COLUMNS CONTINUE clause is not supported. An error will be returned when you perform this operation.

Ignored clauses and options

The option for specifying the CHECKPOINT attribute.