MySQL 5.1 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.9 ALTER VIEW Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER EVENT Syntax
- 12.1.3 ALTER LOGFILE GROUP Syntax
- 12.1.4 ALTER FUNCTION Syntax
- 12.1.5 ALTER PROCEDURE Syntax
- 12.1.6 ALTER SERVER Syntax
- 12.1.7 ALTER TABLE Syntax
- 12.1.8 ALTER TABLESPACE Syntax
- 12.1.9 ALTER VIEW Syntax
- 12.1.10 CREATE DATABASE Syntax
- 12.1.11 CREATE EVENT Syntax
- 12.1.12 CREATE FUNCTION Syntax
- 12.1.13 CREATE INDEX Syntax
- 12.1.14 CREATE LOGFILE GROUP Syntax
- 12.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.16 CREATE SERVER Syntax
- 12.1.17 CREATE TABLE Syntax
- 12.1.18 CREATE TABLESPACE Syntax
- 12.1.19 CREATE TRIGGER Syntax
- 12.1.20 CREATE VIEW Syntax
- 12.1.21 DROP DATABASE Syntax
- 12.1.22 DROP EVENT Syntax
- 12.1.23 DROP FUNCTION Syntax
- 12.1.24 DROP INDEX Syntax
- 12.1.25 DROP LOGFILE GROUP Syntax
- 12.1.26 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.27 DROP SERVER Syntax
- 12.1.28 DROP TABLE Syntax
- 12.1.29 DROP TABLESPACE Syntax
- 12.1.30 DROP TRIGGER Syntax
- 12.1.31 DROP VIEW Syntax
- 12.1.32 RENAME DATABASE Syntax
- 12.1.33 RENAME TABLE 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 a view, which must exist.
The syntax is similar to that for CREATE
VIEW and the effect is the same as for CREATE
OR REPLACE VIEW. See Section 12.1.20, “CREATE VIEW Syntax”. This
statement requires the CREATE VIEW
and DROP privileges for the view,
and some privilege for each column referred to in the
SELECT statement. As of MySQL
5.1.23, ALTER VIEW is allowed only
to the definer or users with the
SUPER privilege.
User Comments
Add your own comment.