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, for the RDB$OBJECT_TYPE enumerated type, examples of object types are:
0 - TABLE
1 - VIEW
2 - TRIGGER …
|
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) |