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 Unique identifying number for the user-defined data type.
creator 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 Y indicates that the user-defined data type does allow nulls. N indicates that the data type does not allow nulls.
width Length of string columns, the precision of numeric columns, and the number of bytes of storage for all other data types.
scale Number of digits after the decimal point for numeric data type columns, and zero for all other data types.
type_name Name for the data type, which must be a valid identifier.
“default” Default value for the data type.
“check” CHECK condition for the data type.
The “default” value and “check” condition
features are not currently supported by Sybase IQ.
