Name 

Type 

Description 

table_id 

BIGINT 

Table this column belongs to. References systables (id) 

position 

SMALLINT 

Logical position of the column, as defined by the order of the columns in the CREATE TABLE statement. Unique to the table. 

id 

SMALLINT 

Physical position of the column on disk. Unique to the table. Primary key columns will always come first in this ordering. 

name 

VARCHAR 

Name of the column, unique to the table. 

type 

SMALLINT 

Data type id of the column 

type_sz 

SMALLINT 

Maximum length of the data in bytes for this column 

default 

VARCHAR 

Constant default value. NULL if default_func is used. 

default_func 

SMALLINT 

Internal function id used to generate default values. -1 if 'default' value column is used. 

nullable 

SMALLINT 

0: NOT NULL option (default); 1: NULL option 

comment 

VARCHAR 

Column comment as set by the COMMENT '' option 

unique 

FLOAT 

Approximate proportion of uniqueness in the column. Where 1 means all fields are unique and 0 would (theoretically) mean that all fields were equal. Generated by GENERATE STATISTICS. 

avg 

INTEGER 

Approximate average size of the column's fields' data. Blob and text columns are not calculated. Generated by GENERATE STATISTICS.