D.9 RDB$DEPENDENCIES
RDB$DEPENDENCIES
stores the dependencies between database objects.
Column Name | Data Type | Description |
---|
RDB$DEPENDENT_NAME
| CHAR(63)
| The name of the view, procedure, trigger, CHECK constraint or computed column the dependency is defined for, i.e., the dependent object |
RDB$DEPENDED_ON_NAME
| CHAR(63)
| The name of the object that the defined object — the table, view, procedure, trigger, CHECK constraint or computed column — depends on |
RDB$FIELD_NAME
| CHAR(63)
| The column name in the depended-on object that is referred to by the dependent view, procedure, trigger, CHECK constraint or computed column |
RDB$DEPENDENT_TYPE
| SMALLINT
| Identifies the type of the dependent object: 0 - table 1 - view 2 - trigger 3 - computed column 4 - CHECK constraint 5 - procedure 6 - index expression 7 - exception 8 - user 9 - column 10 - index 15 - stored function 18 - package header 19 - package body
|
RDB$DEPENDED_ON_TYPE
| SMALLINT
| Identifies the type of the object depended on: 0 - table (or a column in it) 1 - view 2 - trigger 3 - computed column 4 - CHECK constraint 5 - procedure (or its parameter(s)) 6 - index expression 7 - exception 8 - user 9 - column 10 - index 14 - generator (sequence) 15 - UDF or stored function 17 - collation 18 - package header 19 - package body
|
RDB$PACKAGE_NAME
| CHAR(63)
| The package of a procedure or function for which this describes the dependency. |