RDB$DATABASE

From InterBase

Go Up to System Tables


RDB$DATABASE defines a database.

RDB$DATABASE
Column name Data type Length Description

RDB$DESCRIPTION

BLOB

Subtype Text: Contains a user-written description of the database; when a comment is included in a CREATE, ALTER SCHEMA or ALTER DATABASE statement, isql writes to this column.

RDB$RELATION_ID

SMALLINT

For internal use by InterBase

RDB$SECURITY_CLASS

CHAR

67

Subtype 2: Security class defined in the RDB$SECURITY_CLASSES table; the access control limits described in the named security class apply to all database usage.

RDB$CHARACTER_SET_NAME

CHAR

67

Subtype 2; Name of character set

RDB$PAGE_CACHE

INTEGER

Sets database page buffer cache limit. Also, tries to expand cache to that limit.

RDB$PROCEDURE_CACHE

INTEGER

RDB$TRIGGER_CACHE

INTEGER

RDB$RELATION_CACHE

SMALLINT

RDB$FLUSH_INTERVAL

INTEGER

Enables database flush. The interval <number> is interpreted in units of seconds.

RDB$LINGER_INTERVAL

INTEGER

Allows a database to remain in memory after the last user detaches. Interval is seconds.

RDB$RECLAIM_INTERVAL

INTEGER

Reclaim interval is in seconds. Determines how often the garbage collector thread will run to release memory from unused procedures, triggers, and internal system queries back to InterBase memory heap.

RDB$SWEEP_INTERVAL

INTEGER

RDB$GROUP_COMMIT

CHAR(1)

RDB$PASSWORD_DIGEST

VARCHAR(16)