Create view for base table and temporary table : Matadata « Command MySQL « SQL / MySQL






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

Create view for base table and temporary table

    
mysql>
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>








Related examples in the same category

1.Create view for columns
2.Create view for view information from INFORMATION_SCHEMA.VIEWS
3.Create view for column information
4.Create view for user authentication
5.Create view for database authentication
6.Create view on table Privileges
7.Create view for Column Privileges