Check the table name with schema name : INFORMATION_SCHEMA « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. INFORMATION_SCHEMA

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>








Related examples in the same category

1.Check schema name
2.Check characgter set name and collation name
3.Check the CHARACTER_SET_NAME in INFORMATION_SCHEMA.COLLATIONS
4.Show the names of the tables that are stored in the INFORMATION_SCHEMA database.
5.Check information for stored procedures by the table information_schema.routines.
6.Using INFORMATION_SCHEMA Tables
7.Schema of information_schema Tables
8.Check table schema for schema table