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 | 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. |
Constraints |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |