All Collections
MySQL Databases
What Is the Database information_schema on phpMyAdmin?
What Is the Database information_schema on phpMyAdmin?

Exploring the role and use of information_schema in database management

Updated over a week ago

Whenever you access any of your databases via phpMyAdmin, you will find a database named information_schema:

The information_schema database on phpMyAdmin

The information_schema is a system database created by default that stores details about the database, such as database structure, metadata and user privileges, among others.

Developers can use the information contained on this database to gather insights about the database schema, understand the relationships between tables, as well as optimize queries and database performance.

Due to the importance of keeping its integrity, the information_schema database cannot be edited or deleted 💡

Did this answer your question?