D.38 RDB$TYPES

RDB$TYPES stores the defining sets of enumerated types used throughout the system.

Column Name Data Type Description
RDB$FIELD_NAME CHAR(63) Enumerated type name. Each type name masters its own set of types, e.g., object types, data types, character sets, trigger types, blob subtypes, etc.
RDB$TYPE SMALLINT The object type identifier. A unique series of numbers is used within each separate enumerated type. For example, in this selection from the set mastered under RDB$OBJECT_TYPE in RDB$FIELD_NAME, some object types are enumerated: 0 - TABLE 1 - VIEW 2 - TRIGGER 3 - COMPUTED_FIELD 4 - VALIDATION 5 - PROCEDURE  …​
RDB$TYPE_NAME CHAR(63) The name of a member of an enumerated type, e.g., TABLE, VIEW, TRIGGER, etc. in the example above. In the RDB$CHARACTER_SET enumerated type, RDB$TYPE_NAME stores the names of the character sets.
RDB$DESCRIPTION BLOB TEXT Any text comments related to the enumerated type
RDB$SYSTEM_FLAG SMALLINT Flag: indicates whether the type-member is user-defined (value 0) or system-defined (value 1 or greater)