Move View
A view can be moved from one schema to another.Move View Syntax
sales_2017 view from the example_olap
schema to the example_archive schema:
Move View Example
View
ALTER VIEW
Alters the configuration of a view.
The following facet of a view can be altered:
All dependent views,
materialized views,
streams, and
SQL procedures will be dropped.
For example, to move the