ALTER VIEW - Kinetica Docs

Alters the configuration of a view. The following facet of a view can be altered:

Schema

Move View

A view can be moved from one schema to another.

Move View Syntax

ALTER VIEW [<schema name>.]<view name>
< MOVE TO | SET SCHEMA > <new schema name>

All dependent views, materialized views, streams, and SQL procedures will be dropped. For example, to move the sales_2017 view from the example_olap schema to the example_archive schema:

Move View Example

ALTER VIEW example_olap.sales_2017
MOVE TO example_archive;

CREATE MATERIALIZED VIEW ALTER MATERIALIZED VIEW

⌘I

​Move View

Move View