Show the names of the tables that are stored in the INFORMATION_SCHEMA database. : INFORMATION_SCHEMA « Command MySQL « SQL / MySQL






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

Show the names of the tables that are stored in the INFORMATION_SCHEMA database.

        
mysql>
mysql> CREATE OR REPLACE VIEW TABLES
    -> (TABLE_CREATOR, TABLE_NAME,
    -> CREATE_TIMESTAMP, COMMENT) AS
    -> SELECT UPPER(TABLE_SCHEMA), UPPER(TABLE_NAME),
    -> CREATE_TIME, TABLE_COMMENT
    -> FROM INFORMATION_SCHEMA.TABLES
    -> WHERE TABLE_TYPE IN ('BASE TABLE','TEMPORARY');
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>








Related examples in the same category

1.Check schema name
2.Check the table name with schema name
3.Check characgter set name and collation name
4.Check the CHARACTER_SET_NAME in INFORMATION_SCHEMA.COLLATIONS
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