OBJECT_OBJECT_USE
Records objects that have a dependency on another object.
Column name
|
Data type
|
Description
|
OBJECT_SYSID
|
INTEGER
|
System identifier for the object. |
OBJECT_TYPE
|
CHAR(20)
|
One of:
"BASE TABLE"
"VIEW"
"PROCEDURE"
"FUNCTION"
"DOMAIN"
"SEQUENCE"
"CHARACTER SET"
"COLLATION"
"TRANSLATION". |
USED_BY_SYSID
|
INTEGER
|
The system identifier of the referenced object. |
USED_BY_TYPE
|
CHAR(20)
|
One of:
"VIEW"
"PROCEDURE"
"FUNCTION"
"DOMAIN"
"TRIGGER"
"CHARACTER SET"
"COLLATION"
"TRANSLATION". |
Primary key: OBJECT_SYSID, OBJECT_TYPE, USED_BY_SYSID, USED_BY_TYPE
Secondary index: USED_BY_SYSID, USED_BY_TYPE
