SYSCAT.TABDEP catalog view
Each row represents a dependency
of a view or a materialized query table on some other object.
The
view or materialized query table depends on the object of type BTYPE
of name BNAME, so a change to the object affects the view or materialized
query table. Also encodes how privileges on views depend on privileges
on underlying tables and views.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TABSCHEMA | VARCHAR (128) | Schema name of the view or materialized query table. | |
TABNAME | VARCHAR (128) | Unqualified name of the view or materialized query table. | |
DTYPE | CHAR (1) | Type of the depending object.
|
|
OWNER | VARCHAR (128) | Authorization ID of the creator of the view or materialized query table. | |
OWNERTYPE | CHAR (1) |
|
|
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 the view or materialized query table depends. | |
BMODULENAME | VARCHAR (128) | Y | Unqualified name of the module to which the object on which there is a dependency belongs. The null value if not a module object. |
BNAME | VARCHAR (128) | Unqualified name of the object on which the view or materialized query table depends. | |
BMODULEID | INTEGER | Y | Identifier for the module of the object on which the view or materialized query table depends. |
TABAUTH | SMALLINT | Y | The value for this column is encoded as a bitmap, the values of which can be found in
If BTYPE is 'N', 'O', 'S', 'T', 'U', 'V', or 'W', encodes the privileges on the underlying
table or view on which this view or materialized query table depends; the null value
otherwise.<install path>/include/sql.h and are as follows:
|
VARAUTH | SMALLINT | Y | If BTYPE is 'v', encodes the privileges on the underlying global variable on which this view or materialized query table depends; the null value otherwise. |
DEFINER1 | VARCHAR (128) | Authorization ID of the creator of the view or materialized query table. | |
Note:
|