show table mysql

1show tables;
2

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

1SHOW TABLES;

1DESCRIBE my_table;
2

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

1# First, select your database
2USE yourDb;
3
4# Then, simply
5SHOW TABLES;