- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
MySQL 5.0 Reference Manual :: 21 Vues :: 21.4 Syntaxe SHOW CREATE VIEW
Section Navigation [Toggle]
- 21 Vues
- 21.1 Syntaxe ALTER VIEW
- 21.2 Syntaxe de CREATE VIEW
- 21.3 Syntaxe DROP VIEW
- 21.4 Syntaxe SHOW CREATE VIEW
SHOW CREATE VIEW view_name
Cette commande montre la commande CREATE VIEW
qui créera la vue spécifiée.
mysql> SHOW CREATE VIEW v;
+-------+----------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------+
| v | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
+-------+----------------------------------------------------+
Cette commande a été ajoutée en MySQL 5.0.1.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
