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
|