Describe

Get Table Description

DESCRIBE `teacher`;
DESCRIBE `database_name`.`teacher`;
DESCRIBE `teacher` `id`;
DESCRIBE `database_name`.`teacher` `id`;

DESC `teacher`;
DESC `database_name`.`teacher`;

EXPLAIN `teacher`;
EXPLAIN `database_name`.`teacher`;

SHOW FIELDS FROM `teacher`;
SHOW FIELDS FROM `database_name`.`teacher`;
SHOW COLUMNS FROM `student`;
SHOW COLUMNS FROM `database_name`.`teacher`;
SHOW COLUMNS FROM `student` FROM `database_name`;
SHOW CREATE TABLE `teacher`;