ColumnInfo

Members

Variables

charSet

string charSet;

Character set, "<NULL>" if not applicable.

charsMax

long charsMax;

Capacity in characters, -1L if not applicable

colType

string colType;

More detail about the column type, e.g. "int(10) unsigned".

collation

string collation;

Collation, "<NULL>" if not applicable.

comment

string comment;

Any comment that was set at table definition time.

defaultNull

bool defaultNull;

Is the COLUMN_DEFAULT column (in the information schema's COLUMNS table) NULL?

defaultValue

string defaultValue;

The default value as a string if not NULL.

extra

string extra;

Extra information.

index

size_t index;

Zero based index of the column within a table row.

key

string key;

Information about the column's key status, blank if none.

name

string name;

The name of the column.

nullable

bool nullable;

Can the column value be set to NULL

numericPrecision

short numericPrecision;

Presentation information for numerics, -1L if not applicable.

numericScale

short numericScale;

Scale information for numerics or NULL, -1L if not applicable.

octetsMax

long octetsMax;

Capacity in bytes - same as chars if not a unicode table definition, -1L if not applicable.

privileges

string privileges;

Privileges for logged in user.

schema

string schema;

The database that the table having this column belongs to.

table

string table;

The table that this column belongs to.

type

string type;

What type is the column - tinyint, char, varchar, blob, date etc

• ColumnInfo
• MetaData
• MySQLProcedure