Show All Tables in a Database in MySQL

Q

How To Get a List of All Tables in a Database in MySQL?

✍: FYIcenter.com

A

If you want to see the table you have just created, you can use the "SHOW TABLES" command to get a list of all tables in database. The tutorial script gives you a good example:

mysql> SHOW TABLES;
+---------------+
| Tables_in_fyi |
+---------------+
| links         |
| tip           |
+---------------+
3 rows in set (0.00 sec)

 

CREATE, ALTER and DROP Statements in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 190👍, 0💬