syscolumn system table

Each row in the syscolumn system table describes one column.

Column name Column type Description
column_name VARCHAR(128) The name of the column.
default VARCHAR(128) The default value for this column. For example, autoincrement.
domain UNSIGNED INT The column domain, which is an enumerated value indicating the domain of the column.
domain_info UNSIGNED INT Used with a variable sized domain.
nulls VARCHAR(1) Determines if the column allows nulls default.
object_id UNSIGNED INT A unique identifier for that column.
table_id UNSIGNED INT The identifier of the table to which the column belongs.
 Constraints