Sybase Adaptive Server Anywhere - SYSCOLUMN System Table

SYSCOLUMN system table
1004
SYSCOLUMN system table
Column
name
Column type
Column
constraint
Table constraints
table_id UNSIGNED INT NOT NULL Primary key, foreign key
references
SYSTABLE.table_id
column_id UNSIGNED INT NOT NULL Primary key.
pkey CHAR(1) NOT NULL
domain_id SMALLINT NOT NULL foreign key references
SYSDOMAIN.domain_id
nulls CHAR(1) NOT NULL
width SMALLINT NOT NULL
scale SMALLINT NOT NULL
estimate INTEGER NOT NULL
max_identity BIGINT NOT NULL
column_name CHAR(128) NOT NULL
remarks LONG
VARCHAR
"default" LONG
VARCHAR
"check" LONG
VARCHAR
user_type SMALLINT Foreign key references
SYSUSERTYPE.type_id
format_str CHAR(128)
column_type CHAR(1) NOT NULL
remote_name VARCHAR(128)
remote_type UNSIGNED INT
Each column in every table or view is described by one row in
SYSCOLUMN.
table_id A number that uniquely identifies the table or view to which this
column belongs.