System Tables

Go Up to System Tables, Temporary Tables, and Views

The following table lists all InterBase system tables. The names of system tables and the names of the columns of system tables start with RDB$.

System table	Description
RDB$CHARACTER_SETS	Describes the valid character sets available in InterBase.
RDB$JOURNAL_ARCHIVES	Stores information about the repository of database and journal archive files.
RDB$CHECK_CONSTRAINTS	Stores database integrity constraint information for CHECK constraints. In addition, the table stores information for constraints implemented with NOT NULL.
RDB$LOG_FILES	RDB$LOG_FILES is deprecated.
RDB$COLLATIONS	Records the valid collating sequences available for use in InterBase.
RDB$PAGES	Keeps track of each page allocated to the database.
RDB$DATABASE	Defines a database.
RDB$PROCEDURE_PARAMETERS	Stores information about each parameter for each of the procedures of a database.
RDB$DEPENDENCIES	Keeps track of the tables and columns upon which other system objects depend. These objects include views, triggers, and computed columns.
RDB$PROCEDURES	Stores information about a stored procedures of a database.
RDB$ENCRYPTIONS	Describes the characteristics of encryptions stored in the database.
RDB$REF_CONSTRAINTS	Stores information about referential integrity constraints.
RDB$EXCEPTIONS	Describes error conditions related to stored procedures, including user-defined exceptions.
RDB$RELATION_CONSTRAINTS	Stores information about integrity constraints for tables.
RDB$FIELD_DIMENSIONS	Describes each dimension of an array column.
RDB$RELATION_FIELDS	For database tables, lists columns and describes column characteristics for domains.
RDB$FIELDS	Defines the characteristics of a column.
RDB$RELATIONS	Defines some of the characteristics of tables and views.
RDB$FILES	Lists the secondary files and shadow files for a database.
RDB$ROLES	Lists roles that have been defined in the database and the owner of each role.
RDB$FILTERS	Tracks information about a blob filter.
RDB$SECURITY_CLASSES	Defines access control lists and associates them with databases, tables, views, and columns in tables and views.
RDB$FORMATS	Keeps track of the format versions of the columns in a table.
RDB$TRANSACTIONS	Keeps track of all multi-database transactions.
RDB$FUNCTION_ARGUMENTS	Defines the attributes of a function argument.
RDB$TRIGGER_MESSAGES	Defines a trigger message and associates the message with a particular trigger.
RDB$FUNCTIONS	Defines a user-defined function.
RDB$TRIGGERS	Defines triggers.
RDB$GENERATORS	Stores information about generators, which provide the ability to generate a unique identifier for a table.
RDB$TYPES	Records enumerated data types and alias names for InterBase character sets and collation orders.
RDB$INDEX_SEGMENTS	Specifies the columns that comprise an index for a table.
RDB$USER_PRIVILEGES	Keeps track of the privileges assigned to a user through a SQL GRANT statement.
RDB$INDICES	Defines the index structures that allow InterBase to locate rows in the database more quickly.
RDB$USERS	Only permits users in that system table access to the database.
RDB$VIEW_RELATIONS	Not used by SQL objects.

See Also

System Temporary Tables