VMS Help  —  SQL72  Information Tables
    Information tables display internal information about storage
    areas, after-image journals, row caches, database users, the
    database root, and database character sets. Once the information
    tables are created, you can use the INFO_TABLES.SQL script to
    query the tables with the SQL interface.

    Information tables are special read-only tables that can be
    created in an Oracle Rdb database and used to retrieve database
    attributes that are not stored in the existing relational tables.
    Information tables allow interesting database information, which
    is currently stored in an internal format, to be displayed as a
    relational table.

    The script, INFO_TABLES.SQL, is supplied as a part of the Oracle
    Rdb kit in the SQL$SAMPLE directory.
Additional Information: explode extract
All Information Tables Example RDB$STORAGE_AREAS RDB$JOURNALS RDB$CACHES RDB$DATABASE_ROOT RDB$DATABASE_JOURNAL RDB$DATABASE_USERS RDB$LOGICAL_AREAS RDB$CHARACTER_SETS RDB$NLS_CHARACTER_SETS
Close Help