mysql show create table

1DESCRIBE table_name; # To show table structure...

1SHOW CREATE TABLE tablename
2

1DESCRIBE my_table;
2

1SHOW CREATE TABLE tablename

1Copied mysql> SHOW CREATE TABLE t\G
2*************************** 1. row ***************************
3       Table: t
4Create Table: CREATE TABLE `t` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `s` char(60) DEFAULT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

1Copied mysql> DESCRIBE pet;
2+---------+-------------+------+-----+---------+-------+
3| Field   | Type        | Null | Key | Default | Extra |
4+---------+-------------+------+-----+---------+-------+
5| name    | varchar(20) | YES  |     | NULL    |       |
6| owner   | varchar(20) | YES  |     | NULL    |       |
7| species | varchar(20) | YES  |     | NULL    |       |
8| sex     | char(1)     | YES  |     | NULL    |       |
9| birth   | date        | YES  |     | NULL    |       |
10| death   | date        | YES  |     | NULL    |       |
11+---------+-------------+------+-----+---------+-------+