RDB$TYPES

From InterBase
Jump to: navigation, search

Go Up to System Tables


RDB$TYPES records enumerated data types and alias names for InterBase character sets and collation orders. This capability is not available in the current release.

RDB$TYPES
Column name Data Type Length Description

RDB$FIELD_NAME

CHAR

67

Column for which the enumerated data type is being defined.

RDB$TYPE

SMALLINT

Identifies the internal number that represents the column specified above; type codes (same as RDB$DEPENDENT_TYPES):

  • 0 - table
  • 1 - view
  • 2 - trigger
  • 3 - computed_field
  • 4 - validation
  • 5 - procedure

All other values are reserved for future use.

RDB$TYPE_NAME

CHAR

67

Text that corresponds to the internal number.

RDB$DESCRIPTION

BLOB

Subtype Text: Contains a user-written description of the enumerated data type being defined.

RDB$SYSTEM_FLAG

SMALLINT

Indicates whether the data type is:

  • User-defined (value of 0)
  • System-defined (value greater than 0)