Outdated Version
You are viewing an older version of this section. View current production version.
ALTER VIEW
Atomically replace a view with a new view defined by a SELECT
statement. ALTER VIEW
is an online operation and will not cause concurrently executing queries to fail.
Syntax
ALTER
VIEW view_name [(column_list)]
AS select_statement
Remarks
ALTER VIEW
atomically replaces viewview_name
with a new view defined byselect_statement
.ALTER VIEW
privileges are granted only to the user who created the view and toSUPER
users. If aSUPER
user alters a view, that user commandeersALTER
privileges from the user who created the view.
Examples
memsql> ALTER VIEW view_name AS SELECT * FROM table_name WHERE user_id = "real_person";
Related Topics