Switch to: V9V8V7V6V5
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';