triggers

Overview

Stores all table information.

Database

information_schema

Table Information

Column Name	Type	Description
TABLE_CATALOG	varchar(512)	The Catalog to which the table belongs
TABLE_SCHEMA	varchar(64)	The Database to which the table belongs
TABLE_NAME	varchar(64)	The name of the table
TABLE_TYPE	varchar(64)	The type of the table, including: SYSTEM VIEW, VIEW, BASE TABLE
ENGINE	varchar(64)	The storage engine type of the table
VERSION	bigint	Invalid value
ROW_FORMAT	varchar(10)	Invalid value
TABLE_ROWS	bigint	Estimated number of rows in the table
AVG_ROW_LENGTH	bigint	Average row size of the table
DATA_LENGTH	bigint	Estimated size of the table
MAX_DATA_LENGTH	bigint	Invalid value
INDEX_LENGTH	bigint	Invalid value
DATA_FREE	bigint	Invalid value
AUTO_INCREMENT	bigint	Invalid value
CREATE_TIME	datetime	The time when the table was created
UPDATE_TIME	datetime	The time when the table data was last updated
CHECK_TIME	datetime	Invalid value
TABLE_COLLATION	varchar(32)	Fixed value: utf-8
CHECKSUM	bigint	Invalid value
CREATE_OPTIONS	varchar(255)	Invalid value
TABLE_COMMENT	varchar(2048)	Comments on the table