Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$DEPENDENCIES
Firebird Firebird Prev: RDB$DATABASEFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$EXCEPTIONS

RDB$DEPENDENCIES

RDB$DEPENDENCIES stores the dependencies between database objects.

Column Name Data Type Description
RDB$DEPENDENT_NAME CHAR(31) 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(31) 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(31) 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
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
17 - collation

Prev: RDB$DATABASEFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$EXCEPTIONS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$DEPENDENCIES