Appendix D. System Tables
When you create a database, the Firebird engine creates a lot of system tables. Metadata — the descriptions and attributes of all database objects — are stored in these system tables.
System table identifiers all begin with the prefix RDB$.
- Section D.1, “
RDB$AUTH_MAPPING” Stores authentication and other security mappings
- Section D.2, “
RDB$BACKUP_HISTORY” History of backups performed using nBackup
- Section D.3, “
RDB$CHARACTER_SETS” Names and describes the character sets available in the database
- Section D.4, “
RDB$CHECK_CONSTRAINTS” Cross-references between the names of constraints (
NOT NULLconstraints,CHECKconstraints andON UPDATEandON DELETEclauses in foreign key constraints) and their associated system-generated triggers- Section D.5, “
RDB$COLLATIONS” Collation sequences for all character sets
- Section D.6, “
RDB$DATABASE” Basic information about the database
- Section D.7, “
RDB$DB_CREATORS” A list of users granted the
CREATE DATABASEprivilege when using the specified database as a security database- Section D.8, “
RDB$DEPENDENCIES” Information about dependencies between database objects
- Section D.9, “
RDB$EXCEPTIONS” Custom database exceptions
- Section D.10, “
RDB$FIELDS” Column and domain definitions, both system and custom
- Section D.11, “
RDB$FIELD_DIMENSIONS” Dimensions of array columns
- Section D.12, “
RDB$FILES” Information about secondary files and shadow files
- Section D.13, “
RDB$FILTERS” Information about BLOB filters
- Section D.14, “
RDB$FORMATS” Information about changes in the formats of tables
- Section D.15, “
RDB$FUNCTIONS” Information about external functions
- Section D.16, “
RDB$FUNCTION_ARGUMENTS” Attributes of the parameters of external functions
- Section D.17, “
RDB$GENERATORS” Information about generators (sequences)
- Section D.19, “
RDB$INDEX_SEGMENTS” Segments and index positions
- Section D.18, “
RDB$INDICES” Definitions of all indexes in the database (system- or user-defined)
- Section D.20, “
RDB$LOG_FILES” Not used in the current version
- Section D.21, “
RDB$PACKAGES” Stores the definition (header and body) of SQL packages
- Section D.22, “
RDB$PAGES” Information about database pages
- Section D.23, “
RDB$PROCEDURES” Definitions of stored procedures
- Section D.24, “
RDB$PROCEDURE_PARAMETERS” Parameters of stored procedures
- Section D.25, “
RDB$REF_CONSTRAINTS” Definitions of referential constraints (foreign keys)
- Section D.26, “
RDB$RELATIONS” Headers of tables and views
- Section D.27, “
RDB$RELATION_CONSTRAINTS” Definitions of all table-level constraints
- Section D.28, “
RDB$RELATION_FIELDS” Top-level definitions of table columns
- Section D.29, “
RDB$ROLES” Role definitions
- Section D.30, “
RDB$SECURITY_CLASSES” Access control lists
- Section D.31, “
RDB$TRANSACTIONS” State of multi-database transactions
- Section D.32, “
RDB$TRIGGERS” Trigger definitions
- Section D.33, “
RDB$TRIGGER_MESSAGES” Trigger messages
- Section D.34, “
RDB$TYPES” Definitions of enumerated data types
- Section D.35, “
RDB$USER_PRIVILEGES” SQL privileges granted to system users
- Section D.36, “
RDB$VIEW_RELATIONS” Tables that are referred to in view definitions: one record for each table in a view
D.1. RDB$AUTH_MAPPING
RDB$AUTH_MAPPING stores authentication and other security mappings.
| Column Name | Data Type | Description |
|---|---|---|
|
| Name of the mapping |
|
| Using definition:
|
|
| Mapping applies for authentication information from this specific plugin |
|
| Mapping applies for authentication information from this specific database |
|
| The type of authentication object (defined by plugin) to map from, or |
|
| The name of the authentication object to map from |
|
| The type to map to
|
|
| The name to map to |
|
| Flag:
|
|
| Optional description of the mapping (comment) |