Sybase Adaptive Server Anywhere - Page 1023

Chapter 15 System Tables
1005
column_id Each table starts numbering columns at 1. The order of column
numbers determines the order that columns are displayed in the command
SELECT * FROM TABLE
pkey (Y/N) Indicate whether this column is part of the primary key for the
table.
domain_id The data type for the column, indicated by a data type number
listed in the SYSDOMAIN table.
nulls (Y/N) Indicates whether the NULL value is allowed in this column.
width The length of a string column, the precision of numeric columns or
the number of bytes of storage for any other data type.
scale The number of digits after the decimal point for numeric data type
columns, and zero for all other data types.
estimate A self-tuning parameter for the optimizer. Adaptive Server
Anywhere will learn from previous queries by adjusting guesses that are
made by the optimizer.
max_identity The largest value of the column, if it is an
AUTOINCREMENT, IDENTITY, or GLOBAL AUTOINCREMENT
column.
column_name The name of the column.
remarks A comment string.
default The default value for the column. This value is only used when an
INSERT statement does not specify a value for the column.
check. Any CHECK condition defined on the column.
user_type If the column is defined on a user-defined data type, the data
type is held here.
format_str Currently unused.
column_type The type of column. Contains C for a computed column and
R for other columns.
remote_name The name of the remote column.
remote_type The type of the remote column. This value is defined by the
remote server or interface.