Background documentationcreate_view_statement Locate this document in the navigation structure


The CREATE VIEW (create_view_statement) SQL statement is supported with a restricted syntax by SAP MaxDB. The following restrictions exist in SAP MaxDB for the syntax of the CREATE VIEW statement:

  • SAP MaxDB rejects the specification of FORCE and NOFORCE.

  • A Constraint Name given to the CHECK OPTION is not stored in the database catalog. If no constraint name is specified, SAP MaxDB does not generate a name.

  • View tables that are changeable in Oracle are not necessarily changeable in SAP MaxDB. This is especially true for view tables whose definition contains subqueries.