Table of Contents
ALTER VIEW
ALTER VIEW statement is used to change existed view without touching its sub-objects as triggers, …
Syntax
alter_view_statement
: ALTER VIEW view_name [ (column_name_list) ]
AS query_expression
[ WITH CHECK OPTION ]
Arguments
See CREATE VIEW command for description of arguments.
Examples
ALTER VIEW wMale AS SELECT fldName, fldLastName FROM tblPerson WHERE fldGender = 'M';