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.


______________

Find expert web hosting services at SiteGround.com: secure web servers, cPanel, Fantastico, PHP, MySQL, FTP, web hosting tutorials, and more.


Rating

Please indicate if this article was helpful for you.
rating :  5.0 from 5
views :  156
votes :  1

Related Articles

Views

Valid XHTML 1.0 Strict Valid CSS!