RDB$CONFIG
RDB$CONFIG
is a virtual table showing the configuration settings of the current database for the current connection.
Table RDB$CONFIG
is populated from in-memory structures upon request and its instance is preserved for the SQL query lifetime.For security reasons, access to this table is allowed for administrators only.Non-privileged users see no rows in this table (and no error is raised).
Column Name | Data Type | Description |
---|---|---|
|
|
Unique row identifier, no special meaning |
|
|
Setting name (e.g. |
|
|
Actual value of setting |
|
|
Default value of setting (defined in the Firebird code) |
|
|
TRUE if value is explicitly configured, FALSE when default |
|
|
Name of the configuration file (relative to the Firebird root directory) where this setting was taken from, or special value |