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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite database reference » UltraLite system tables


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.