RDB$DEPENDENCIES

Go Up to System Tables

RDB$DEPENDENCIES keeps track of the tables and columns upon which other system objects depend. These objects include views, triggers, and computed columns. InterBase uses this table to ensure that a column or table cannot be deleted if it is used by any other object.

Column name	Data type	Length	Description
RDB$DEPENDENT_NAME	CHAR	67	Subtype 2; names the object this table tracks: a view, trigger, or computed column.
RDB$DEPENDED_ON_NAME	CHAR	67	Subtype 2; names the table referenced by the object named above.
RDB$FIELD_NAME	CHAR	67	Subtype 2; names the column referenced by the object named above.
RDB$DEPENDENT_TYPE	SMALLINT		Describes the object type of the object referenced in the RDB$DEPENDENT_NAME column; type codes (RDB$TYPES): 0 - table 1 - view 2 - trigger 3 - computed_field 4 - validation 5 - procedure 7 - exception 8 - user 9 - field 10 - index All other values are reserved for future use.
RDB$DEPENDED_ON_TYPE	SMALLINT		Describes the object type of the object referenced in the RDB$DEPENDED_ON_NAME column; type codes (RDB$TYPES): 0 - table 1 - view 2 - trigger 3 - computed_field 4 - validation 5 - procedure 7 - exception 8 - user 9 - field 10 - index 11 - generator 14 - External Functions 15 - Encryption All other values are reserved for future use.