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.