VMS Help  —  ORACLE_RDB72, System Tables, RDB$OBJECT_SYNONYMS
    The RDB$OBJECT_SYNONYMS system table is created with synonyms
    are enabled to record the synonym name, type, and target. The
    following table provides information on the columns of the
    RDB$OBJECT_SYNONYMS system table.

                                Data
    Column Name                 Type      Summary Description

    RDB$CREATED                 date vms  Time and date when synonym
                                          entry was created.
    RDB$LAST_ALTERED            date vms  Time and date when synonym
                                          entry was last altered.
    RDB$DESCRIPTION             list      A user-supplied description
                                of byte   of the synonym.
                                varying
    RDB$EXTENSION_PARAMETERS    list      Reserved for future use.
                                of byte
                                varying
    RDB$FLAGS                   integer   Flags.
    RDB$OBJECT_TYPE             integer   The type of synonym.
    RDB$SYNONYM_NAME            char(31)  The synonym to be used
                                          by queries. This name
                                          is unique within the
                                          RDB$OBJECT_SYNONYMS system
                                          table.
    RDB$SYNONYM_VALUE           char(31)  name of the object for
                                          which the synonym is
                                          defined.
    RDB$SYNONYM_CREATOR         char(31)  Creator of the synonym
                                          entry.

1  –  RDB$FLAGS

    Represents flags for RDB$OBJECT_SYNONYMS system table.

    Bit
    Position   Description

    0          When set, this bit indicates that this synonym
               references another synonym.
    1          Reserved for future use.
    2          Indicates that the synonym was created by RENAME
               statement.
Close Help