SHOW CREATE TABLE

语法说明

以列表的形式展现当前数据库创建的某个表的表结构。

语法结构

1. > SHOW CREATE TABLE tbl_name

示例

1. drop table if exists t1;
2. create table t1(
3. col1 int comment 'First column',
4. col2 float comment '"%$^&*()_+@!',
5. col3 varchar comment 'ZD5lTndyuEzw49gxR',
6. col4 bool comment ''
7. );
8. mysql> show create table t1;
9. +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
10. | Table | Create Table                                                                                                                                                                                                     |
11. +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
12. | t1    | CREATE TABLE `t1` (
13. `col1` INT DEFAULT NULL COMMENT 'First column',
14. `col2` FLOAT DEFAULT NULL COMMENT '"%$^&*()_+@!',
15. `col3` VARCHAR(65535) DEFAULT NULL COMMENT 'ZD5lTndyuEzw49gxR',
16. `col4` BOOL DEFAULT NULL
17. ) |
18. +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
19. 1 row in set (0.00 sec)