View information for all tables in the MySQL library--information_schema

The first query looks at how many tables, table names, etc. in the library
SELECT * FROM INFORMATION_SCHEMA. TABLES

Information_schema This data sheet holds information about all databases in the MySQL server. such as database name, database table, table column data type and access permissions. Simply put, this MySQL server, exactly what database, the database has what tables, each table of the field type is what the database to what permissions to access, and so on, and so on in the Information_schema table.

MySQL's INFORMATION_SCHEMA database contains tables and views that provide a way to access database metadata.

Metadata is data about the data, such as the database name or table name, the data type of the column, or access permissions. Some of the other terms used to express this information include the data dictionary and the system catalog.

Here are some explanations for some important data dictionary tables:

Schemata table: Provides information about the database.

Tables table: Gives information about the tables in the database.

Columns table: Gives the column information in the table.

Statistics Table: Provides information about the index of a table.

User_privileges table: Gives information about the full range of permissions. This information is derived from the Mysql.user authorization form.

Schema_privileges Table: Provides information about the program (database) permissions. This information is from the Mysql.db authorization form.

Table_privileges table: Gives information about table permissions. This information is derived from the Mysql.tables_priv authorization form.

Column_privileges table: Gives information about column permissions. This information is derived from the Mysql.columns_priv authorization form.

Character_sets Table: Provides information about the available character sets.

Collations table: Provides cross-reference information about each character set.

Collation_character_set_applicability table: Indicates the character set that can be used for proofreading.

Table_constraints table: A table describing the existence of constraints.

Key_column_usage table: Describes the key columns that have constraints.

Routines Table: Provides information about storing subroutines (stored programs and functions). At this point, the routines table does not contain a custom function (UDF).

Views Table: Gives information about the view in the database.

Triggers table: Provides information about the triggering program.

View information for all tables in the MySQL library--information_schema