MySqlConnector


Tables Schema

The Tables schema provides information about tables.

Column NameData TypeDescription
TABLE_CATALOGstring
TABLE_SCHEMAstring
TABLE_NAMEstring
TABLE_TYPEstring
ENGINEstring
VERSIONstring
ROW_FORMATstring
TABLE_ROWSlong
AVG_ROW_LENGTHlong
DATA_LENGTHlong
MAX_DATA_LENGTHlong
INDEX_LENGTHlong
DATA_FREElong
AUTO_INCREMENTlong
CREATE_TIMEDateTime
UPDATE_TIMEDateTime
CHECK_TIMEDateTime
TABLE_COLLATIONstring
CHECKSUMstring
CREATE_OPTIONSstring
TABLE_COMMENTstring

The following restrictions are supported:

Restriction NameRestriction DefaultRestriction Number
CatalogTABLE_CATALOG1
SchemaTABLE_SCHEMA2
TableTABLE_NAME3
TableTypeTABLE_TYPE4