RDB$TYPES

From InterBase

Go Up to System Tables


RDB$TYPES records enumerated data types and alias names for InterBase character sets and collation orders.

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
  • 6 - expression index
  • 7 - exception
  • 8 - user
  • 9 - field
  • 10 - index
  • 11 - generator
  • 12 - user group
  • 13 - role
  • 14 - udf
  • 15 - encryption
  • 16 - subscription

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)