SQL$HELP_OLD72.HLB  —  CREATE  VIEW  Format
  CREATE VIEW --> <view-name> -------------------------+
    +--------------------------------------------------+
    ++-----------------------------------+-------------+
     +-> STORED NAME IS <stored-name> ---+             |
  +----------------------------------------------------+
  ++------------------------>------------------------+-+
   +-> ( -+-> <column-name> -+--------------+-+-> ) -+ |
          | +----------------+              | |        |
          | ++-+------------------------+-+-+ |        |
          |  | +-> sql-and-dtr-clause --+ |   |        |
          |  +-------------<--------------+   |        |
          +----------------- , <--------------+        |
  +----------------------------------------------------+
  +-> AS select-expr ---+------------------------+-->
                        +-> check-option-clause -+

  select-expr =

  -+-+->  select-clause  ------------+-+------+
   | +-> ( select-expr )  -----------+ |      |
   | +->   TABLE table-ref ----------+ |      |
   +------ select-merge-clause <-------+      |
     +------------------- <-------------------+
     +-+--------------------+--+------------------+--+--------------------+->
       +-> order-by-clause -+  +-> offset-clause -+  +-> limit-to-clause -+

  sql-and-dtr-clause =

  -+-> QUERY HEADER IS -+> <quoted-string> +-------------------+->
   |                    +------ / <--------+                   |
   +-> EDIT STRING IS <quoted-string> -------------------------+
   |                                                           |
   +-> QUERY NAME FOR -+-> DTR --------+-> IS <quoted-string> -+
   |                   +-> DATATRIEVE -+                       |
   +-> DEFAULT VALUE FOR -+-> DTR --------+-> IS literal   ----+
                          +-> DATATRIEVE -+

  check-option-clause =

  WITH CHECK OPTION --+----------------------------------+-->
                      +-> CONSTRAINT <check-option-name> +
Close Help