VMS Help  —  SQL72  System Tables
    Oracle Rdb stores information about the database as a set of
    tables called system tables. The system tables are the definitive
    source of Oracle Rdb metadata. Metadata defines the structure
    of the database; for example, metadata defines the fields that
    comprise a particular table and the fields that can index that
    table.

    The definitions of most system tables are standard and are likely
    to remain constant in future versions of Oracle Rdb.

    Under each Help topic for a particular system table, BLR refers
    to binary language representation. This is low-level syntax used
    internally to represent Oracle Rdb data manipulation operations.
Additional Information: explode extract
Special Notes Read Only Access Example All System Tables RDB$CATALOG_SCHEMA RDB$COLLATIONS RDB$CONSTRAINTS RDB$CONSTRAINT_RELATIONS RDB$DATABASE RDB$FIELD_VERSIONS RDB$PARAMETER_SUB_TYPE RDB$FIELD_SUB_TYPE RDB$FIELDS RDB$GRANTED_PROFILES RDB$INDEX_SEGMENTS RDB$INDICES RDB$INTERRELATIONS RDB$MODULES RDB$OBJECT_SYNONYMS RDB$PARAMETERS RDB$PRIVILEGES RDB$PROFILES RDB$QUERY_OUTLINES RDB$RELATION_CONSTRAINTS RDB$RELATION_CONSTRAINT_FLDS RDB$RELATION_FIELDS RDB$RELATIONS RDB$ROUTINES RDB$SEQUENCES RDB$STORAGE_MAPS RDB$STORAGE_MAP_AREAS RDB$SYNONYMS RDB$TRIGGERS RDB$VIEW_RELATIONS RDB$WORKLOAD
Close Help