Mega Code Archive

 

Categories / MySQL / Command Mysql

 

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>