You are viewing an older version of this section. View current production version.
Atomically replace a view with a new view defined by a
ALTER VIEW is an online operation and will not cause concurrently executing queries to fail.
ALTER VIEW view_name [(column_list)] AS select_statement
ALTER VIEWatomically replaces view
view_namewith a new view defined by
ALTER VIEWprivileges are granted only to the user who created the view and to
SUPERusers. If a
SUPERuser alters a view, that user commandeers
ALTERprivileges from the user who created the view.
memsql> ALTER VIEW view_name AS SELECT * FROM table_name WHERE user_id = "real_person";