OBJECT_COLUMN_USE
Records columns referenced by other database objects.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table column. |
USED_BY_SYSID
|
INTEGER
|
The system identifier of the referencing object. |
USED_BY_TYPE
|
CHAR(20)
|
One of:
"VIEW"
"PROCEDURE"
"FUNCTION"
"CHECK"
"TRIGGER". |
PRIVILEGE_TYPE
|
CHAR(20)
|
One of:
"INSERT"
"DELETE"
"SELECT"
"UPDATE"
"REFERENCES". |
Primary key: TABLE_SYSID, COLUMN_NAME, USED_BY_SYSID, USED_BY_TYPE, PRIVILEGE_TYPE
Secondary index: USED_BY_SYSID, USED_BY_TYPE
