07 Sep 2010 
Support Center » Knowledgebase » What are the information_schema tables I see when viewing my database?
 What are the information_schema tables I see when viewing my database?
Article The answer could probably best be answered by MySQL.com -

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 http://dev.mysql.com/doc/refman/5.0/en/information-schema.html


Article Details
Article ID: 42
Created On: 11 Aug 2009 9:04 PM

 This article was helpful  This article was not helpful

 Back
 Log in  
Username:
Password:
Remember Me:
 
 Search
 Article Options
Home | Submit a Ticket | Knowledgebase | News | Downloads
Language:

Copyright © 2009 TLD Web Hosting,LLC.All trademarks are property of their legal owner.