Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$TYPES
Firebird Firebird Prev: RDB$TRIGGER_MESSAGESFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$USER_PRIVILEGES

RDB$TYPES

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

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

Prev: RDB$TRIGGER_MESSAGESFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$USER_PRIVILEGES
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$TYPES