D.7 RDB$DATABASE

RDB$DATABASE stores basic information about the database. It contains only one record.

Column Name Data Type Description
RDB$DESCRIPTION BLOB TEXT Database comment text
RDB$RELATION_ID SMALLINT A number that steps up by one each time a table or view is added to the database
RDB$SECURITY_CLASS CHAR(63) The security class defined in RDB$SECURITY_CLASSES in order to apply access control limits common to the entire database
RDB$CHARACTER_SET_NAME CHAR(63) The name of the default character set for the database set in the DEFAULT CHARACTER SET clause when the database is created. NULL for character set NONE.
RDB$LINGER INTEGER Number of seconds “delay” (established with the ALTER DATABASE SET LINGER statement) until the database file is closed after the last connection to this database is closed (in SuperServer). NULL if no delay is set.
RDB$SQL_SECURITY BOOLEAN The default SQL SECURITY mode (DEFINER or INVOKER) applied to newly created objects: NULL - initial default (INVOKER) FALSE - INVOKER TRUE - DEFINER