skip to main content
Designing and coding the IP : Views : Command syntax
 

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.