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