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 view view_name with a new view defined by select_statement.
  • ALTER VIEW privileges are granted only to the user who created the view and to SUPER users. If a SUPER user alters a view, that user commandeers ALTER 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