DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) alter-view

Info Catalog (mysql.info) views (mysql.info) views (mysql.info) create-view
 
 19.1 `ALTER VIEW' Syntax
 ========================
 
      ALTER
          [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
          [DEFINER = { USER | CURRENT_USER }]
          [SQL SECURITY { DEFINER | INVOKER }]
          VIEW VIEW_NAME [(COLUMN_LIST)]
          AS SELECT_STATEMENT
          [WITH [CASCADED | LOCAL] CHECK OPTION]
 
 This statement changes the definition of an existing view. The syntax
 is similar to that for `CREATE VIEW'. See  create-view. This
 statement requires the `CREATE VIEW' and `DROP' privileges for the
 view, and some privilege for each column referred to in the `SELECT'
 statement.
 
 This statement was added in MySQL 5.0.1. The `DEFINER' and `SQL
 SECURITY' clauses may be used as of MySQL 5.0.16 to specify the security
 context to be used when checking access privileges at view invocation
 time. For details, see  create-view.
 
Info Catalog (mysql.info) views (mysql.info) views (mysql.info) create-view
automatically generated byinfo2html