CHAR(31)

The name of the table or view that the column belongs to

CHAR(31)

Domain name on which the column is based, either a user-defined one specified in the table definition or one created automatically by the system using the set of attributes defined. The attributes are in the table RDB$FIELDS: this column matches RDB$FIELDS.RDB$FIELD_NAME.

CHAR(31)

Not currently used

CHAR(31)

Only populated for a view, it is the name of the column from the base table

VARCHAR(127)

Not used

SMALLINT

The zero-based ordinal position of the column in the table or view, numbering from left to right

BLOB TEXT

Not used

SMALLINT

Indicates whether the column is a regular one (value 1) or a computed one (value 0)

SMALLINT

An ID assigned from RDB$RELATIONS.RDB$FIELD_ID at the time the column was added to the table or view. It should always be treated as transient

SMALLINT

For a view column, the internal identifier of the base table from which this field derives

BLOB TEXT

Comments related to the table or view column

BLOB BLR

The value stored for the DEFAULT clause for this column, if there is one, written in binary language representation (BLR)

SMALLINT

Indicates whether the column is user-defined (value 0) or system-defined (value 1 or greater)

CHAR(31)

May reference a security class defined in RDB$SECURITY_CLASSES, in order to apply access control limits to all users of this column

CHAR(31)

Not used

SMALLINT

Indicates whether the column is nullable (NULL) non-nullable (value 1)

BLOB TEXT

The source text of the DEFAULT clause, if any

SMALLINT

The identifier of the collation sequence in the character set for the column, if it is not the default collation

CHAR(31)

Internal generator name for generating an identity value for the column.

SMALLINT

The identity type of the column

NULL - not an identity column 0 - identity column, GENERATED ALWAYS (not supported in Firebird 3.0, will be introduced in Firebird 4.0) 1 - identity column, GENERATED BY DEFAULT