SYSCAT.DATATYPEDEP catalog view
Each row represents a dependency of a user-defined data type on some other object.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TYPESCHEMA | VARCHAR (128) | Schema name of the data type. | |
TYPEMODULENAME | VARCHAR (128) | Y | Module name of the data type. |
TYPENAME | VARCHAR (128) | Unqualified name of the data type. | |
TYPEMODULEID | INTEGER | Y | Identifier for the module of the data type. |
BTYPE | CHAR (1) | Type of object on which there is a dependency. Possible values
are:
|
|
BSCHEMA | VARCHAR (128) | Schema name of the object on which there is a dependency. | |
BMODULENAME | VARCHAR (128) | Y | Module name of the object on which there is a dependency. |
BNAME | VARCHAR (128) | Unqualified name of the object on which there is a dependency. | |
BMODULEID | INTEGER | Y | Identifier for the module of the object on which there is a dependency. |
TABAUTH | SMALLINT | Y | The value for this column is encoded as a bitmap, the values of which can be found in
If BTYPE = 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges on the table or view
that are required by the dependent data type; the null value otherwise.<install path>/include/sql.h and are as follows:
|