Knowledge Base Article

What is the information_schema database?

In MySQL version 5.02 and above there is an additional database called information_schema. This database provides access to the database metadata. This includes the name of a database or a table, the data type of a column, access privileges, etc.


information_schema is the information database where the information about all the other databases is kept. It is a built-in virtual database with the sole purpose of providing information about the database system itself. The MySQL server automatically populates the tables in the information_schema. 

 

The important thing to remember about the information_schema database is that you can query it, but you cannot change its structure or modify its data.



Rating

Please indicate if this article was helpful for you.

rating :  4.9 from 5
views :  2049
votes :  24

Haven't found what you are looking for? Suggest an article HERE.

powered by

Valid XHTML 1.0 Strict Valid CSS!