VMS Help  —  SQL72  Information Tables, Example
    The following example shows how to query one of the information
    tables created by the INFO_TABLES.SQL script:

    SQL> SELECT * FROM RDB$LOGICAL_AREAS WHERE RDB$LOGICAL_AREA_NAME='JOBS';
    RDB$LOGICAL_AREA_ID  RDB$AREA_ID  RDB$RECORD_LENGTH  RDB$THRESHOLD1_PERCENT
     RDB$THRESHOLD2_PERCENT  RDB$THRESHOLD3_PERCENT  RDB$ORDERED_HASH_OFFSET
      RDB$RECORD_TYPE  RDB$LOGICAL_AREA_NAME
                     95            7                 41                       0
                          0                       0                        0
                    1  JOBS

    1 row selected
Close Help