What is information_schema in MySQL? (2)

information_schema Database Table Description:

schemata: Provides information for all databases in the current MySQL instance. This table is the result of show databases.

TABLES: Provides information about the tables in the database, including views. Describes in detail which schema, table type, table engine, creation time, and so on, a table belongs to. This table is the result of show tables from SchemaName.

COLUMNS: Provides column information in the table. Describes in detail all the columns of a table and the information for each column. This table is the result of show columns from Schemaname.tablename.

STATISTICS: Provides information about the index of a table. This table is the result of show index from Schemaname.tablename.

user_privileges (User rights): Gives information about the full range of permissions. This information is derived from the Mysql.user authorization form. Non-standard tables.

schema_privileges (program permissions): Provides information about the permissions of the program (database). This information is from the Mysql.db authorization form. Non-standard tables.

table_privileges (table permissions): Gives information about table permissions. This information is derived from the Mysql.tables_priv authorization form. Non-standard tables.

column_privileges (column permissions): Gives information about column permissions. This information is derived from the Mysql.columns_priv authorization form. Non-standard tables.

character_sets (character set): Provides information about the available character sets for MySQL instances. This table is the show CHARACTER set result set.

collations: Provides cross-reference information about each character set.

collation_character_set_applicability: Indicates the character set that can be used for proofreading. These columns are equivalent to the first two display fields of show collation.

table_constraints: A table describing the existence of constraints. And the constraint type of the table.

key_column_usage: Describes the key columns that have constraints.

ROUTINES: Provides information about storing subroutines (stored programs and functions). At this point, the routines table does not contain a custom function (UDF). A column named "Mysql.proc name" indicates the corresponding INFORMATION_SCHEMA. The Mysql.proc table column for the routines table.

Views: Gives information about the view in the database. You need to have show views permission, otherwise you cannot view the view information.

TRIGGERS: Provides information about the triggering program. You must have super privileges to view the table

What is information_schema in MySQL? (2)