RDB$RELATION FIELDS
Go Up to System Tables
For database tables, RDB$RELATION_FIELDS
lists columns and describes column characteristics for domains.
SQL columns are defined in RDB$RELATION_FIELDS
. The column name is correlated in the RDB$FIELD_SOURCE
column to an underlying entry in RDB$FIELDS
that contains a system name (“SQL$<n>”). This entry includes information such as column type and length. For both domains and simple columns, this table may contain default and nullability information.
Column name | Data Type | Length | Description |
---|---|---|---|
|
|
67 |
Column name defined by the user. |
|
|
67 |
Table name defined by the user. |
|
|
67 |
Internal Column name that matches up with RDB$FIELDS.RDB$FIELD_NAME. |
|
|
67 |
Alternate column name for use in |
|
|
67 |
Views only: The name of the column from
|
|
|
125 |
Not used in SQL. |
|
|
The position of the column in relation to other columns:
If two or more columns in the same table have the same value for this column, those columns appear in random order. | |
|
|
Not used in SQL. | |
|
|
Not used by InterBase; included for compatibility with other DSRI-based systems. | |
|
|
Identifier for use in BLR (Binary Language Representation) to name the column.
| |
|
|
Alias used to qualify view columns by specifying the table location of the base column; it must have the same value as the alias used in the view BLR (Binary Language Representation) for this context stream. | |
|
|
Subtype Text: User-written description of the column being defined. | |
|
|
Subtype BLR: BLR (Binary Language Representation) for default clause. | |
|
|
Indicates whether the column is:
| |
|
|
67 |
Names a security class defined in the |
|
|
67 |
Reserved for future use. |
|
|
Indicates whether the column may contain | |
|
|
Subtype Text: SQL source to define defaults. | |
|
|
Unique identifier for the collation sequence. | |
|
|
Identifies encryption ID from RDB$ENCRYPTIONS used to encrypt this column. | |
|
|
Subtype BLR: BLR (Binary Language Representation) for decrypt default clause. | |
|
|
Subtype Text: SQL to define decrypt default. | |
|
|
2 |
1 = One or more subscriptions on the field |