Each row in the syscolumn system table describes a column.
| Column name | Column type | Description |
|---|---|---|
| table_id | UNSIGNED INTEGER | The identifier of the table to which the column belongs. |
| column_id | UNSIGNED INTEGER | A unique identifier for the column. |
| column_name | VARCHAR(128) | The name of the column. See Domain interface [UltraLiteJ]. |
| column_flags | TINY |
A bitwise combination of the following flags describing the attributes:
|
| column_domain | TINY | The column domain, which is an enumerated value indicating the domain of the column in the low-order 6 bits. The remaining bits are used internally. |
| column_length | UNSIGNED SHORT |
The column length. For VARCHAR and BINARY type columns, which are defined in the Domain interface, this is the maximum length in bytes. For NUMERIC type columns, the precision is stored in the first byte, and the scale is stored in the second byte. |
| column_default_value | VARCHAR(128) |
The default value for this column, which is specified by one of the COLUMN_DEFAULT values in the ColumnSchema interface. For example, COLUMN_DEFAULT_AUTOINC denotes an auto-incrementing default value. If a varchar column has DEFAULT AUTOFILENAME specified, then it stores the parameters prefix and extension using the encoding prefix|extension. |
| filename_colid | UNSIGNED INTEGER | Stores the column ID of the column that contains the file name for a LONG BINARY column declared as STORE AS FILE; otherwise, this column is null. |
Constraints |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |