Database information_schema - table COLUMNS

[ Browse ]    [ Select ]    [ Insert ]    [ Empty ]

Field Type Attributes Null Default Extra Action
TABLE_CATALOG  varchar(512)   Yes  NULL    Change Drop Primary Index Unique
TABLE_SCHEMA  varchar(64)   Yes      Change Drop Primary Index Unique
TABLE_NAME  varchar(64)   Yes      Change Drop Primary Index Unique
COLUMN_NAME  varchar(64)   Yes      Change Drop Primary Index Unique
ORDINAL_POSITION  bigint(21)   Yes    Change Drop Primary Index Unique
COLUMN_DEFAULT  varchar(64)   Yes  NULL    Change Drop Primary Index Unique
IS_NULLABLE  varchar(3)   Yes      Change Drop Primary Index Unique
DATA_TYPE  varchar(64)   Yes      Change Drop Primary Index Unique
CHARACTER_MAXIMUM_LENGTH  bigint(21)   Yes  NULL    Change Drop Primary Index Unique
CHARACTER_OCTET_LENGTH  bigint(21)   Yes  NULL    Change Drop Primary Index Unique
NUMERIC_PRECISION  bigint(21)   Yes  NULL    Change Drop Primary Index Unique
NUMERIC_SCALE  bigint(21)   Yes  NULL    Change Drop Primary Index Unique
CHARACTER_SET_NAME  varchar(64)   Yes  NULL    Change Drop Primary Index Unique
COLLATION_NAME  varchar(64)   Yes  NULL    Change Drop Primary Index Unique
COLUMN_TYPE  longtext   Yes      Change Drop Primary Index Unique
COLUMN_KEY  varchar(3)   Yes      Change Drop Primary Index Unique
EXTRA  varchar(20)   Yes      Change Drop Primary Index Unique
PRIVILEGES  varchar(80)   Yes      Change Drop Primary Index Unique
COLUMN_COMMENT  varchar(255)   Yes      Change Drop Primary Index Unique