(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