MySQL Forums
Forum List  »  Views

tables in information_schema are views?or temporary tables?
Posted by: aaron chan
Date: February 18, 2017 12:34AM

1、show create table information_schema.views indicate this "views" object is a temporary table:
CREATE TEMPORARY TABLE `VIEWS` (````````)
2、the table_type column value from "views" object indicate this is a "system view"?
mysql> select table_type from information_schema.tables where table_name='views'
;
+-------------+
| table_type |
+-------------+
| SYSTEM VIEW |
+-------------+
1 row in set (0.00 sec)

So,what on earth are all the objects in information_schema,if they are views,what are their base tables?if they are temporary tables,how do they gain the metadata that we need?

Options: ReplyQuote


Subject
Views
Written By
Posted
tables in information_schema are views?or temporary tables?
1259
February 18, 2017 12:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.