MySQL 5.1 Reference Manual :: 13 SQL Statement Syntax :: 13.5 Database Administration Statements :: 13.5.4 SHOW Syntax :: 13.5.4.10 SHOW CREATE VIEW Syntax
Section Navigation [Toggle]
- 13.5.4 SHOW Syntax
- 13.5.4.1 SHOW AUTHORS Syntax
- 13.5.4.2 SHOW CHARACTER SET Syntax
- 13.5.4.3 SHOW COLLATION Syntax
- 13.5.4.4 SHOW COLUMNS Syntax
- 13.5.4.5 SHOW CONTRIBUTORS Syntax
- 13.5.4.6 SHOW CREATE DATABASE Syntax
- 13.5.4.7 SHOW CREATE EVENT
- 13.5.4.8 SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax
- 13.5.4.9 SHOW CREATE TABLE Syntax
- 13.5.4.10 SHOW CREATE VIEW Syntax
- 13.5.4.11 SHOW DATABASES Syntax
- 13.5.4.12 SHOW ENGINE Syntax
- 13.5.4.13 SHOW ENGINES Syntax
- 13.5.4.14 SHOW ERRORS Syntax
- 13.5.4.15 SHOW EVENTS
- 13.5.4.16 SHOW GRANTS Syntax
- 13.5.4.17 SHOW INDEX Syntax
- 13.5.4.18 SHOW INNODB STATUS Syntax
- 13.5.4.19 SHOW OPEN TABLES Syntax
- 13.5.4.20 SHOW PLUGINS Syntax
- 13.5.4.21 SHOW PRIVILEGES Syntax
- 13.5.4.22 SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax
- 13.5.4.23 SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax
- 13.5.4.24 SHOW PROCESSLIST Syntax
- 13.5.4.25 SHOW SCHEDULER STATUS Syntax
- 13.5.4.26 SHOW STATUS Syntax
- 13.5.4.27 SHOW TABLE STATUS Syntax
- 13.5.4.28 SHOW TABLES Syntax
- 13.5.4.29 SHOW TRIGGERS Syntax
- 13.5.4.30 SHOW VARIABLES Syntax
- 13.5.4.31 SHOW WARNINGS Syntax
SHOW CREATE VIEW view_name
This statement shows a CREATE VIEW
statement that creates the given view.
mysql> SHOW CREATE VIEW v;
+------+----------------------------------------------------+
| View | Create View |
+------+----------------------------------------------------+
| v | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
+------+----------------------------------------------------+
Use of SHOW CREATE VIEW requires the
SHOW VIEW privilege and the
SELECT privilege for the view in question.
You can also obtain information about view objects from
INFORMATION_SCHEMA, which contains a
VIEWS table. See
Section 22.15, “The INFORMATION_SCHEMA VIEWS Table”.
User Comments
Add your own comment.