The SQL statement ALTER TABLE (alter_table_statement) is known in SAP DB, 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 DB and are rejected.
• SAP DB cannot deactivate constraints. SAP DB therefore ignores the specification of DISABLE.
• SAP DB cannot delete any UNIQUE constraints using the DROP clause. The DROP INDEX statement must be used for this instead.
• When columns are inserted, SAP DB automatically inserts these columns in all view tables that use the "*" in the <select_list>, in order to identify all columns of the table.