D.26. RDB$RELATIONS
RDB$RELATIONS stores the top-level definitions and attributes of all tables and views in the system.
| Column Name | Data Type | Description |
|---|---|---|
|
| Stores the query specification for a view, in the binary language representation (BLR).
The field stores |
|
| Contains the original source text of the query for a view, in SQL language.
User comments are included.
The field stores |
|
| Could store comments related to the table or view |
|
| Internal identifier of the table or view |
|
| indicates whether the table or view is user-defined (value 0) or system-defined (value 1 or greater) |
|
| The total length of the database key. For a table: 8 bytes. For a view, the length is 8 multiplied by the number of tables referenced by the view |
|
| Internal use, points to the relation’s record in |
|
| The field ID for the next column to be added. The number is not decremented when a column is dropped. |
|
| Table or view name |
|
| May reference a security class defined in the table |
|
| The full path to the external data file if the table is defined with the |
|
| Table metadata description, used internally for optimization |
|
| Could store comments related to the external file of an external table |
|
| The user name of the user who created the table or view originally |
|
| Default security class, used when a new column is added to the table |
|
| Internal flags |
|
| The type of the relation object being described:
|