RDB$DATABASE
Go Up to System Tables
RDB$DATABASE defines a 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, | |
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) |