How To Get a List of All Tables in a Database

Q

How To Get a List of All Tables in a Database? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements

✍: 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)

2007-05-11, 4234👍, 0💬