create_view_statement

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

·        MaxDB does not accept the specification of FORCE or NOFORCE.

·        A constraint_name given to the CHECK OPTION is not stored in the database catalog. If no constraint name is specified, MaxDB does not generate a name.

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