Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite System Table Reference » UltraLite system tables

systable system table Next Page

syscolumn system table


Each row in the syscolumn system table describes one column.

Columns
Column nameDescriptionTypeData constraintIntegrity constraints

column_name

A unique identifier of the column.

VARCHAR(128)

NOT NULL

default

The default value for this column. For example, autoincrement.

VARCHAR(128)

domain

The column domain, which is an enumerated value indicating the domain of the column.

UNSIGNED INT

NOT NULL

domain_info

Used with a variable sized domain.

SMALLINT

NOT NULL

nulls

Determines if the column allows nulls default.

CHAR(1)

NOT NULL

object_id

A unique identifier for that column.

UNSIGNED INT

NOT NULL

Primary key.

table_id

The identifier of the table to which the column belongs.

UNSIGNED INT

NOT NULL

Primary key.

Foreign key references object_id in systable.