VMS Help  —  SQL72  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.
Additional Information: explode extract
RDB$FLAGS
Close Help