CREATE VIEW

Grammar Syntax

The CREATE VIEW syntax is a grammar that does not fit on just one page, but here is an overview.

<view definition> ::=
  CREATE [ RECURSIVE ] VIEW <table name>  <view specification> 
      AS <query expression>  [ WITH [ <levels clause>  ] CHECK OPTION ]

Click here to go to the ANSI SQL Standard specification for this syntax.

Navigate to the following pages to get more details about the translation spec for CREATE TABLE syntax.

1. Basic View

2. Recursive Clause

3. As Select