Knowledgebase: MySQL
What are the information_schema tables I see when viewing my database?
Posted by Arvand Sabetian (Import) on 20 February 2009 12:50 AM
The answer could probably best be answered by -

INFORMATION_SCHEMA provides access to database metadata.
Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.
INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them.

Therefore, you can safely ignore these tables. They are read-only so they can't be edited or removed. For more information on this, please visit
(195 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).