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> +