Background documentationSQL Mode Locate this document in the navigation structure


The SAP MaxDB database system supports different SQL language variants (SQL modes).

SQL Modes




SAP MaxDB SQL definition


ORACLE 7 SQL definition

For Data Definition Language (DDL) statements, the database system supports SQL modes other than INTERNAL only to a limited extent.

When you open a database session, you can specify the SQL mode. The default value is INTERNAL.

Note Note

If nothing else is specified, the documentation describes the SQL statements available in the INTERNAL SQL mode: SQL Syntax.

End of the note.

More Information

SQL Reference Manual,

Loader, SQLMODE Command