|
Each row in the SYSUSERTYPE system view holds a description of a user-defined data type. The underlying system table for this view is ISYSUSERTYPE.
| Column name | Column type | Column constraint |
|---|---|---|
| type_id | SMALLINT | NOT NULL |
| creator | UNSIGNED INT | NOT NULL |
| domain_id | SMALLINT | NOT NULL |
| nulls | CHAR(1) | NOT NULL |
| width | UNSIGNED INT | NOT NULL |
| scale | SMALLINT | NOT NULL |
| type_name | CHAR(128) | NOT NULL |
| "default" | LONG VARCHAR | |
| "check" | LONG VARCHAR |
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 system view.
nulls (Y/N/U) Indicates whether the user-defined data type allows nulls. A value of U indicates that nullability is unspecified.
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.
type_name The name for the data type.
"default" The default value for the data type.
"check" The CHECK condition for the data type.
PRIMARY KEY (type_id)
FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)
FOREIGN KEY (domain_id) references SYS.ISYSDOMAIN (domain_id)
UNIQUE (type_name)