Quadcap Embeddable Database

• QED Home
• User's Guide
• Developer's Guide
• API Documentation
• SQL Reference
• FAQ
• Changes

Quadcap Software

• Home
• Download
• Products
• Services
• Purchase
• Support
• About

This statement is used to create a view. A view is a named virtual table which is derived from one or more base tables. By default, views are created in the current schema.

createViewStmt
  :  "create" "view" sqlId 
    (  LPAREN idList RPAREN 
    |  
    ) 
    "as" queryExpression 
    (  "with" 
      (  "cascaded" 
      |  
      ) 
      "check" "option" 
    |  
    ) 
    
  ;

CREATE VIEW TEMP_SS (EMPNUM,GRADE,CITY)
AS     SELECT EMPNUM, GRADE, CITY
FROM   STAFF
WHERE  GRADE > 12;

• CHECK OPTION only supports CASCADED; LOCAL CHECK OPTION is not allowed.