CREATE TABLE SYS.SYSUSERTYPE ( type_id SMALLINT NOT NULL, creator UNSIGNED INT NOT NULL, domain_id UNSIGNED INT NOT NULL, nulls CHAR(1) NOT NULL, width SMALLINT NOT NULL, scale SMALLINT NOT NULL, type_name CHAR(128) NOT NULL, "default" LONG VARCHAR NULL, "check" LONG VARCHAR NULL, format_str CHAR(128), super_type_id SMALLINT NULL, UNIQUE ( type_name ), PRIMARY KEY ( type_id ), FOREIGN KEY ( creator ) REFERENCES SYS.SYSUSERPERM ( user_id ), FOREIGN KEY REFERENCES SYS.SYSDOMAIN, FOREIGN KEY ( super_type_id ) REFERENCES SYS.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 owner of the data type.
domain_id Identifies the data type for the column by the data type number listed in the SYSDOMAIN table.
nulls A Y indicates that the user-defined data type does allow nulls. A N indicates that the data type does not allow nulls.
width This column contains the length of string columns, the precision of numeric columns, and the number of bytes of storage for all other data types.
scale The number of digits after the decimal point for numeric data type columns, and zero for all other data types.
type_name The name for the data type, which must be a valid identifier.
"default" The default value for the data type.
"check" The CHECK condition for the data type.
The “default” value and “check” condition
features are not currently supported by Sybase IQ.
