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>