RDB$TYPES

Reserved Words and KeywordsMonitoring Tables

`RDB$TYPES`

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

Column Name Data Type Description

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)

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)

`RDB$CHECK_CONSTRAINTS`

RDB$CHECK_CONSTRAINTS provides the cross references between the names of system-generated triggers for constraints and the names of the associated constraints (NOT NULL constraints, CHECK constraints and the ON UPDATE and ON DELETE clauses in foreign key constraints).

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$CONSTRAINT_NAME`	`CHAR(63)`	Constraint name, defined by the user or automatically generated by the system
`RDB$TRIGGER_NAME`	`CHAR(63)`	For a `CHECK` constraint, it is the name of the trigger that enforces this constraint.For a `NOT NULL` constraint, it is the name of the table the constraint is applied to.For a foreign key constraint, it is the name of the trigger that enforces the `ON UPDATE`, `ON DELETE` clauses.

RDB$CONSTRAINT_NAME

CHAR(63)

Constraint name, defined by the user or automatically generated by the system

RDB$TRIGGER_NAME

CHAR(63)

For a CHECK constraint, it is the name of the trigger that enforces this constraint.For a NOT NULL constraint, it is the name of the table the constraint is applied to.For a foreign key constraint, it is the name of the trigger that enforces the ON UPDATE, ON DELETE clauses.