Each row in the syscolumn system table describes one column.
| Column name | Column type | Description |
|---|---|---|
| column_name | VARCHAR(128) | A unique identifier 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 | SMALLINT | Used with a variable sized domain. |
| nulls | CHAR(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. |
PRIMARY KEY( table_id, object_id )
FOREIGN KEY (table_id) REFERENCES systable (object_id)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |