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.