VMS Help  —  SQL72  System Tables, RDB$SYNONYMS
    The RDB$SYNONYMS system table connects the user-visible name of
    an object to the stored name of an object. The user-visible name
    of an object might be replicated in multiple schemas, whereas
    the stored name of an object is unique across all schemas and
    catalogs. This table is present only in databases that have the
    SQL multischema feature enabled.

    Unlike rows in other system tables, the rows in the RDB$SYNONYMS
    system table are compressed. The following table provides
    information on the columns of the RDB$SYNONYMS system table.

                                Data
    Column Name                 Type      Summary Description

    RDB$SCHEMA_ID               integer   The RDB$CATALOG_SCHEMA_ID
                                          of the schema to which this
                                          object belongs.
    RDB$USER_VISIBLE_NAME       char(31)  The name of an object as it
                                          appears to the user.
    RDB$OBJECT_TYPE             integer   A value that represents
                                          the type of an object, as
                                          follows:

                                          o  8

                                             A constraint.

                                          o  19

                                             A domain (global field).

                                          o  26

                                             An index.

                                          o  31

                                             A system table.

                                          o  36

                                             A view.

                                          o  60

                                             A sequence.

                                          o  67

                                             A storage map.

                                          o  81

                                             A trigger.

                                          o  117

                                             A collating sequence.

                                          o  180

                                             An outline.

                                          o  192

                                             A type.

    RDB$STORED_NAME             char(31)  The name of an object as
                                          is actually stored in the
                                          database.
    RDB$SECURITY_CLASS          char(20)  Reserved for future use.
Close Help