MySQL Programming Interview Question:

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

Submitted by: Administrator

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;
<pre>+---------------+
| Tables_in_ggl |
+---------------+
| links |
| tip |
+---------------+</pre>
3 rows in set (0.00 sec)

Submitted by: Administrator