Command syntax

The following SQL commands are supported to allow defining views:

CREATE VIEW [qualifier].[owner.]view_name [(view_column_name,...)] AS subquery
DROP VIEW [qualifier].[owner].view_name

If the CREATE VIEW/DROP VIEW command does not specify the qualifier and owner, the current qualifier returned by the GETINFO operation is used for qualifier and the user name is used for owner.