INFORMATION_SCHEMA
The INFORMATION_SCHEMA database is a virtual database that MySQL uses to store metadata about the server and its databases. It provides access to the read-only information about database objects and server statistics. The tables within the INFORMATION_SCHEMA database are organized hierarchically making it easy to navigate and query different aspects of the MySQL server.
MySQL INFORMATION_SCHEMA Tables
MySQL provides a powerful set of system tables known as the INFORMATION_SCHEMA tables that contain metadata about the database system, including the databases, tables, columns, indexes, privileges, and more.
These tables are a valuable resource for database administrators and developers to query and analyze information about the MySQL server and its objects.