ALTER DERIVED VIEW Statements

ALTER DERIVED VIEW Syntax

ALTER DERIVED VIEW [<view_name>] AS <sql_query_contents>

The following query changes an existing derived view, MyViewName, to a new SQL query:

ALTER DERIVED VIEW [MyViewName] AS SELECT * FROM Customers WHERE TimeModified > '3/1/2020';