FirebirdSQL logo

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$.

List of System Tables
[fblangref-appx04-authmapping]

Stores authentication and other security mappings

[fblangref-appx04-backuphistory]

History of backups performed using nBackup

[fblangref-appx04-charactersets]

Names and describes the character sets available in the database

[fblangref-appx04-chkconstraints]

Cross-references between the names of constraints (NOT NULL constraints, CHECK constraints and ON UPDATE and ON DELETE clauses in foreign key constraints) and their associated system-generated triggers

[fblangref-appx04-collations]

Collations for all character sets

[fblangref-appx04-config]

Virtual table with configuration settings applied for the current database

[fblangref-appx04-database]

Basic information about the database

[fblangref-appx04-dbcreators]

A list of users granted the CREATE DATABASE privilege when using the specified database as a security database

[fblangref-appx04-dependencies]

Information about dependencies between database objects

[fblangref-appx04-exceptions]

Custom database exceptions

[fblangref-appx04-fields]

Column and domain definitions, both system and custom

[fblangref-appx04-fielddims]

Dimensions of array columns

[fblangref-appx04-files]

Information about secondary files and shadow files

[fblangref-appx04-filters]

Information about BLOB filters

[fblangref-appx04-formats]

Information about changes in the formats of tables

[fblangref-appx04-functions]

Information about external functions

[fblangref-appx04-funcargs]

Attributes of the parameters of external functions

[fblangref-appx04-generators]

Information about generators (sequences)

[fblangref-appx04-idxsegments]

Segments and index positions

[fblangref-appx04-indices]

Definitions of all indexes in the database (system- or user-defined)

[fblangref-appx04-logfiles]

Not used in the current version

[fblangref-appx04-packages]

Stores the definition (header and body) of SQL packages

[fblangref-appx04-pages]

Information about database pages

[fblangref-appx04-procedures]

Definitions of stored procedures

[fblangref-appx04-procparams]

Parameters of stored procedures

[fblangref-appx04-refconstr]

Definitions of referential constraints (foreign keys)

[fblangref-appx04-relations]

Headers of tables and views

[fblangref-appx04-relconstr]

Definitions of all table-level constraints

[fblangref-appx04-relfields]

Top-level definitions of table columns

[fblangref-appx04-roles]

Role definitions

[fblangref-appx04-secclasses]

Access control lists

[fblangref-appx04-timezones]

Time zones

[fblangref-appx04-transacs]

State of multi-database transactions

[fblangref-appx04-triggers]

Trigger definitions

[fblangref-appx04-trigmsgs]

Trigger messages

[fblangref-appx04-types]

Definitions of enumerated data types

[fblangref-appx04-userprivs]

SQL privileges granted to system users

[fblangref-appx04-viewrelns]

Tables that are referred to in view definitions: one record for each table in a view

RDB$AUTH_MAPPING

RDB$AUTH_MAPPING stores authentication and other security mappings.

Column Name Data Type Description

RDB$MAP_NAME

CHAR(63)

Name of the mapping

RDB$MAP_USING

CHAR(1)

Using definition:

P - plugin (specific or any)
S - any plugin serverwide
M - mapping
* - any method

RDB$MAP_PLUGIN

CHAR(63)

Mapping applies for authentication information from this specific plugin

RDB$MAP_DB

CHAR(63)

Mapping applies for authentication information from this specific database

RDB$MAP_FROM_TYPE

CHAR(63)

The type of authentication object (defined by plugin) to map from, or * for any type

RDB$MAP_FROM

CHAR(255)

The name of the authentication object to map from

RDB$MAP_TO_TYPE

SMALLINT

The type to map to

0 - USER
1 - ROLE

RDB$MAP_TO

CHAR(63)

The name to map to

RDB$SYSTEM_FLAG

SMALLINT

Flag:

0 - user-defined
1 or higher - system-defined

RDB$DESCRIPTION

BLOB TEXT

Optional description of the mapping (comment)