mysql>
mysql> SELECT TABLE_NAME
-> FROM INFORMATION_SCHEMA.TABLES
-> WHERE TABLE_SCHEMA = 'TEST'
-> ORDER BY TABLE_NAME;
+--------------+
| TABLE_NAME |
+--------------+
| residents |
| sexes |
| stratforders |
| t1 |
| t2 |
+--------------+
5 rows in set (0.00 sec)
mysql>