Skip to main content
Skip to main content

tables

Overview

Stores all table information under the current catalog.

Database

information_schema

Table Information

ColumnTypeDescription
TABLE_CATALOGVARCHAR(512)Catalog
TABLE_SCHEMAVARCHAR(64)Database
TABLE_NAMEVARCHAR(64)Table
TABLE_TYPEVARCHAR(64)Table type: SYSTEM VIEW, VIEW, BASE TABLE
ENGINEVARCHAR(64)Table engine type
VERSIONBIGINTInvalid value
ROW_FORMATVARCHAR(10)Invalid value
TABLE_ROWSBIGINTEstimated row count
AVG_ROW_LENGTHBIGINTAverage row size
DATA_LENGTHBIGINTEstimated table size
MAX_DATA_LENGTHBIGINTInvalid value
INDEX_LENGTHBIGINTInvalid value
DATA_FREEBIGINTInvalid value
AUTO_INCREMENTBIGINTInvalid value
CREATE_TIMEDATETIMECreate time
UPDATE_TIMEDATETIMEUpdate time
CHECK_TIMEDATETIMEInvalid value
TABLE_COLLATIONVARCHAR(32)Fix value: utf-8
CHECKSUMBIGINTInvalid value
CREATE_OPTIONSVARCHAR(255)Invalid value
TABLE_COMMENTVARCHAR(2048)Comment

Example

None