MySQL 5.5 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.7 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 FUNCTION Syntax
- 12.1.4 ALTER PROCEDURE Syntax
- 12.1.5 ALTER SERVER Syntax
- 12.1.6 ALTER TABLE Syntax
- 12.1.7 ALTER VIEW Syntax
- 12.1.8 CREATE DATABASE Syntax
- 12.1.9 CREATE EVENT Syntax
- 12.1.10 CREATE FUNCTION Syntax
- 12.1.11 CREATE INDEX Syntax
- 12.1.12 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.13 CREATE SERVER Syntax
- 12.1.14 CREATE TABLE Syntax
- 12.1.15 CREATE TRIGGER Syntax
- 12.1.16 CREATE VIEW Syntax
- 12.1.17 DROP DATABASE Syntax
- 12.1.18 DROP EVENT Syntax
- 12.1.19 DROP FUNCTION Syntax
- 12.1.20 DROP INDEX Syntax
- 12.1.21 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.22 DROP SERVER Syntax
- 12.1.23 DROP TABLE Syntax
- 12.1.24 DROP TRIGGER Syntax
- 12.1.25 DROP VIEW Syntax
- 12.1.26 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.16, “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.
ALTER VIEW is allowed only to the
definer or users with the SUPER
privilege.
User Comments
Add your own comment.