Day 12 INFORMATION_SCHEMA database

Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because it is not stored any data directly, it provides information about metadata and other information which mysql has – data dictionary and system catalog.

In short you can view the configuration and other database metadata and information about objects.

Some of the tables from this tables are:

CHARACTER_SETS         –    complete Character sets information

COLLATIONS             – complete Collactions information

COLUMNS                               – all column information from all schemas

COLUMN_PRIVILEGES                    –

ENGINES

EVENTS

FILES

GLOBAL_STATUS

GLOBAL_VARIABLES

KEY_COLUMN_USAGE

OPTIMIZER_TRACE

PARAMETERS

PARTITIONS

PROCESSLIST

PROFILING

REFERENTIAL_CONSTRAINTS

SCHEMATA

SCHEMA_PRIVILEGES

SESSION_STATUS

SESSION_VARIABLES

STATISTICS

TABLES

TABLESPACES

TABLE_CONSTRAINTS

TABLE_PRIVILEGES

TRIGGERS

USER_PRIVILEGES

VIEWS

INNODB_*

 

 

 

Reference:

https://www.ppgia.pucpr.br/pt/arquivos/techdocs/mysql/information-schema.html

Advertisements
This entry was posted in General, MySQL, Others, What I learned today and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.