Information about the information_schema database in MySQL

This article provides information about the information_schema database in MySQL.

About the information_schema database

The information_schema database is a virtual database that MySQL uses to store information about your databases and other settings. For example, you can query the information_schema database to obtain information about character sets, statistics, and much more.

Although you can query tables in the information_schema database, you cannot modify them. You also cannot delete the information_schema database.

To see an example of the information_schema database in action, please see this article.

More Information

For more information about the information_schema database in MySQL, please visit http://dev.mysql.com/doc/refman/5.5/en/information-schema.html.

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.