alter_table_statement

The SQL statement ALTER TABLE (alter_table_statement) is known in 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 MaxDB and are rejected.

·        MaxDB cannot deactivate constraints. MaxDB thus ignores the specification of DISABLE.

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

·        When columns are inserted, 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.