show tables mysql

1show tables;
2

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

1SHOW TABLES;

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+---------+-------------+------+-----+---------+-------+

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

1Press CTRL+C to copy SHOW [EXTENDED] [FULL] TABLES
2    [{FROM | IN} db_name]
3    [LIKE 'pattern' | WHERE expr]