Knowledge Base
MilesWeb / MySQL

Learning About information_schema Database

Approx. read time : 2 min

There is an additional database named as information_schema in the MySQL version 5.02. You can find this database in cPanel-> Databases -> phpMyAdmin. It allows you to access the database metadata for corresponding user.

information_schema database stores the information about all other databases. For example, data type of columns, a database or a table name, access privileges, etc. It is a virtual database that is in-built with an aim to deliver information about the database system itself. The tables within this database are automatically populated by the MySQL server.

You should remember one major thing about the information_schema database and it is possible to query it, but its structure can’t be changed and data can’t be modified.

When you query the information_schema database, you get plenty of options on controlling the changes in the structure of your database and also, offer some level of automation on the database layer. For getting these two, it is important to follow some rules, like internal data modeling rules, naming convention, etc. You can also exploit it to document your database.

Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.