SHOW CREATE VIEW

语法说明

这个语句显示了创建命名视图的 CREATE VIEW 语句。

语法结构

1. > SHOW CREATE VIEW view_name

示例

1. create table test_table(col1 int, col2 float, col3 bool, col4 Date, col5 varchar(255), col6 text);
2. create view test_view as select * from test_table;
3. mysql> show create view test_view;
4. +-----------+---------------------------------------------------+
5. | View      | Create View                                       |
6. +-----------+---------------------------------------------------+
7. | test_view | create view test_view as select * from test_table |
8. +-----------+---------------------------------------------------+
9. 1 row in set (0.01 sec)