SQL$HELP_OLD72.HLB  —  ALTER  VIEW  Format
  ALTER VIEW <view-name> -+-+-->  AS <select-expr> -----------------+-+->
                          | +-->  <check-option-clause> ------------+ |
                          | +-->  COMMENT IS -+-> 'text-literal'--+-+ |
                          | |                 +--------- / <------+ | |
                          | +-->  RENAME TO <new-view-name>  -------+ |
                          | +-->  WITH NO CHECK OPTION  ------------+ |
                          +-------------------  <---------------------+

  select-expr =

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

  check-option-clause =

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