Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Check the table name with schema name

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>