Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  MySQL  >  Learning About information_schema Database
Top Scroll

Learning About information_schema Database

 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.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.