SYSTABLEDEP
The SYSTABLEDEP view records the dependencies of materialized query tables.
The following table describes the columns in the SYSTABLEDEP view:
Column name | System Column Name | Data Type | Description |
---|---|---|---|
TABLE_SCHEMA | TABSCHEMA | VARCHAR(128) | Name of the SQL schema that contains the table, view or alias |
TABLE_NAME | TABNAME | VARCHAR(128) | Name of the table, view or alias. This is the SQL table, view or alias name if it exists; otherwise, it is the system table, view or alias name. |
OBJECT_SCHEMA | BSCHEMA | VARCHAR(128) | Name of the SQL schema that contains the object. |
OBJECT_NAME | BNAME | VARCHAR(128) | Name of the object the materialized query table is dependent on. |
OBJECT_TYPE | BTYPE | CHAR(24) | Indicates the object type of the
object referenced in the materialized query table:
|
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number of the object. |
SYSTEM_TABLE_SCHEMA | SYS_DNAME | CHAR(10) | System schema name |
SYSTEM_TABLE_NAME | SYS_TNAME | CHAR(10) | System table name. |
PARM_SIGNATURE | SIGNATURE | VARCHAR(10000) Nullable
|
This column identifies the routine
signature. Contains the null value if the object is not a routine. |