ColumnInfo

A struct to hold column metadata

struct ColumnInfo {

string schema;

string table;

size_t index;

bool defaultNull;

string defaultValue;

bool nullable;

long charsMax;

long octetsMax;

short numericPrecision;

short numericScale;

string charSet;

string collation;

string colType;

string extra;

string privileges;

string comment;

}

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 default value 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

Meta

Source

See Implementation

mysql metadata structs