A tabela SYSDEPENDENCIES registra as dependências entre os objetos.
O esquema é SYSIBM.
The SYSDEPENDENCIES table records the dependencies between objects.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| BNAME |
VARCHAR(128)
NOT NULL |
Name of the object on which another object is dependent.
If BTYPE is F, the name is the specific name of the function.
If BTYPE is W or Z, the name is the name of the table for which the period is defined. |
G |
| BSCHEMA |
VARCHAR(128)
NOT NULL |
Schema or qualifier of the object on which another object is dependent. |
G |
| BCOLNAME |
VARCHAR(128)
NOT NULL
WITH DEFAULT |
Column name of the object on which another object is dependent. |
G |
| BCOLNO |
SMALLINT
NOT NULL
WITH DEFAULT |
Column number of the object on which another object is dependent. |
G |
| BTYPE |
CHAR(1)
NOT NULL |
The type of object that is identified by BNAME, BSCHEMA, and BCOLNAME:
- C
- Column
- E
- INSTEAD OF trigger
- F
- Function
- G
- Global temporary table
- H
- Global variable
- I
- Index
- M
- Materialized query table
- O
- Procedure
- P
- Partitioned table space
- Q
- Sequence
- R
- Table space
- S
- Synonym
- T
- Table
- U
- Distinct type
- V
- View
- W
- SYSTEM_TIME period
- Z
- BUSINESS_TIME period
- 0 (zero)
- Alias
|
G |
| BOWNER |
VARCHAR(128)
NOT NULL
WITH DEFAULT |
Authorization ID of the owner of the object on which another object is dependent. |
G |
| BOWNERTYPE |
CHAR(1)
NOT NULL |
Type of creator of the object on which another object is dependent:
- L
- Role
- blank
- Authorization ID that is not a role
|
G |
| DNAME |
VARCHAR(128)
NOT NULL |
Name of the object that has dependencies on another object. |
G |
| DSCHEMA |
VARCHAR(128)
NOT NULL |
Schema or qualifier of the object that has dependencies on another object. |
G |
| DVERSION |
VARCHAR(122)
NOT NULL
WITH DEFAULT |
The version identifier of the object that is identified by DSCHEMA and DNAME if the object has a version.
This column contains a zero length string for the objects that are created prior to Version 10 and for the rows that correspond to objects without versions. |
G |
| DCOLNAME |
VARCHAR(128)
NOT NULL |
Column name of the object that has dependencies on another object. |
G |
| DCOLNO |
SMALLINT
NOT NULL
WITH DEFAULT |
Column number of the object that has dependencies on another object. |
G |
| DTYPE |
CHAR(1)
NOT NULL |
The type of the object that is identified by DSCHEMA, DNAME, DCOLNAME, and DVERSION:
- B
- Trigger package for basic trigger
- C
- Generated column
- F
- Function
- I
- Index
- M
- Materialized query table
- O
- Procedure
- V
- View
- X
- Row permission
- Y
- Column mask
- 1
- Trigger package for an advanced trigger
|
G |
| DOWNER |
VARCHAR(128)
NOT NULL |
Authorization ID of the owner of the object that has dependencies on another object. |
G |
| DOWNERTYPE |
CHAR(1)
NOT NULL |
Type of creator of the object that has dependencies on another object:
- L
- Role
- blank
- Authorization ID if not a role
|
G |
| IBMREQD |
CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see
Release dependency indicators.
The value in this field is not a reliable indicator of release dependencies. |
G |
| BAUTH |
SMALLINT
NOT NULL
WITH DEFAULT |
The privilege that is held on the object on which another object is dependent. |
G |
