Appendix D. System Tables - D.9 RDB$DEPENDENCIES - 《Firebird 4.0 Language Reference》

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.