MySqlConnector


Columns Schema

The Columns schema provides information about columns (in all tables).

Column NameData TypeDescription
TABLE_CATALOGstring
TABLE_SCHEMAstring
TABLE_NAMEstring
COLUMN_NAMEstring
ORDINAL_POSITIONuint
COLUMN_DEFAULTstring
IS_NULLABLEstring
DATA_TYPEstring
CHARACTER_MAXIMUM_LENGTHlong
NUMERIC_PRECISIONulong
NUMERIC_SCALEulong
DATETIME_PRECISIONuint
CHARACTER_SET_NAMEstring
COLLATION_NAMEstring
COLUMN_TYPEstring
COLUMN_KEYstring
EXTRAstring
PRIVILEGESstring
COLUMN_COMMENTstring
GENERATION_EXPRESSIONstring
SRS_IDstring

The following restrictions are supported:

Restriction NameRestriction DefaultRestriction Number
CatalogTABLE_CATALOG1
SchemaTABLE_SCHEMA2
TableTABLE_NAME3
ColumnCOLUMN_NAME4