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.