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.