Sybase Adaptive Server Anywhere - SYSUSERTYPE System Table

Chapter 15 System Tables
1049
SYSUSERTYPE system table
Column name
Column
type
Column
constraint
Table constraints
type_id UNSIGNED
INT
NOT NULL Primary key
creator UNSIGNED
INT
NOT NULL Foreign key references
SYSUSERPERM.user_id
domain_id UNSIGNED
INT
NOT NULL Foreign key references
SYSDOMAIN
nulls CHAR(1) NOT NULL
width UNSIGNED
INT
NOT NULL
scale UNSIGNED
INT
NOT NULL
type_name CHAR(128) NOT NULL Unique
"default" LONG
VARCHAR
NULL
"check" LONG
VARCHAR
NULL
format_str CHAR(128)
super_type_id UNSIGNED
INT
NULL Foreign key references
SYSUSERTYPE.type_id.
Each row holds a description of a user-defined data type.
type_id A unique identifying number for the user-defined data type.
creator The user number of the owner of the data type.
domain_id The data type on which this user defined data type is based,
indicated by a data type number listed in the SYSDOMAIN table.
nulls (Y/N) Indicates whether the user-defined data type allows nulls.
width The length of a string column, the precision of a numeric column, 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.