ALTER VIEW
ALTER VIEW
changes the definition of a view.
Warning
This feature is not supported yet.
Instead, you can redefine a view by dropping it and recreating it with a different query or options:
DROP VIEW redefined_view;
CREATE VIEW redefined_view ...;
Please note that the two statements are executed separately, unlike a single ALTER VIEW
statement. If a view is recreated in this way, it might be possible to observe the view in a deleted state for a brief moment.