Background documentationalter_table_statement Locate this document in the navigation structure


The ALTER TABLE (alter_table_statement) SQL statement is known in SAP MaxDB, but has different syntax and semantics to Oracle (ALTER TABLE statement).

  • The variants PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, DROP, and ALLOCATE are meaningless in SAP MaxDB and are rejected.

  • SAP MaxDB cannot deactivate constraints. SAP MaxDB therefore ignores the specification of DISABLE.

  • SAP MaxDB cannot delete any UNIQUE constraints using the DROP clause. The DROP INDEX statement must be used for this instead.

  • When columns are inserted, SAP MaxDB automatically inserts these columns in all view tables that use the "*" in the <select_list>, in order to identify all columns of the table.