To see created table structure show create table command is used
Syntax
1 2 | SHOW CREATE TABLE TABLE_NAME; |
Example
1 2 | SHOW CREATE TABLE student; |
Result
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------+ | Table | Create Table| +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------+ | student | CREATE TABLE `student` ( `id` int(11) DEFAULT NULL, `first_name` varchar(30) DEFAULT NULL, `last_name` varchar(30) DEFAULT NULL, `semester` varchar(20) DEFAULT NULL, `address` varchar(80) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------+ 1 row in set (0.17 sec) |
To avoid showing leading and trailing dots we use \G with command syntax is as below
Example
1 2 | SHOW CREATE TABLE student\G |
Result
*************************** 1. row ***************************
Table: student
Create Table: CREATE TABLE student
(
id
int(11) DEFAULT NULL,
first_name
varchar(30) DEFAULT NULL,
last_name
varchar(30) DEFAULT NULL,
semester
varchar(20) DEFAULT NULL,
address
varchar(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)