Synonym (object)

Represents a unique name (alias) for a physical object, instead of using an object's physical name. This includes a table, view, materialized view, procedure, sequence, function, package, or another synonym.

Valid Owning Object Types

Name DBMS Brands/Versions
Cached_ViewDB2 for LUW 9.1+, DB2 for z/OS 8.1+, Informix 5.0+, Oracle 9.0+, SQL Server 9.0+
EntityDB2 for LUW 8.1+, DB2 for z/OS 6.0+, Informix 7.0+, Oracle 8.1+, Red Brick 5.0+
FunctionOracle 9.0+
ModelOracle 8.1+, SQL Server 9.0+, SQL Azure 10.0+
ModuleDB2 for LUW 9.7+, SQL Azure 10.0+
Oracle_PackageOracle 9.0+, SQL Azure 10.0+
SequenceDB2 for LUW 9.7+, Oracle 9.0+, SQL Azure 10.0+
Stored_ProcedureOracle 9.0+
SynonymDB2 for LUW 9.1+, Oracle 9.0+, SQL Azure 10.0+
ViewDB2 for LUW 9.1+, DB2 for z/OS 2.0+, Oracle 9.0+

Valid Owned Object Types

Name DBMS Brands/Versions
Extended_NotesAll
PermissionSQL Server 9.0+, SQL Azure 10.0+
SynonymDB2 for LUW 9.1+, Oracle 9.0+, SQL Azure 10.0+

Tagged Values

Name Value
Long_Id{E7AB3CC0-47AD-4A10-8972-C0FB869EE7CB}+4020001e
tag_DBMS_Brands_And_VersionsDB2 for LUW 8.1+, DB2 for z/OS 2.0+, Informix 5.0+, Oracle 6.0+, SQL Server 9.0+, SQL Azure 10.0+
tag_Display_Name_ResourceSynonym
tag_Display_Name_Resource_PluralSynonyms
tag_Has_Dbms_Equivalenttrue
tag_Has_Udp_Editortrue
tag_Is_Abstractfalse
tag_Is_Physicaltrue
tag_Is_Transformabletrue
tag_Legacy_Object_Is_Dependenttrue
tag_Legacy_Ownership_Depth256
tag_Physical_Name_TextSynonym

Valid Property Types

Name DBMS Brands/Versions
Built_In_IdAll
DB2_Gen_As_SynonymDB2 for z/OS 6.0+
DB2_Synonym_DatabaseDB2 for z/OS 6.0+
Database_IdAll
DefinitionAll
Dependent_Objects_RefAll
Do_Not_GenerateAll
History_ListAll
Informix_Synonym_DatabaseInformix 7.0+
Is_PublicDB2 for LUW 9.7+, Informix 9.0+
LabelAccess 1.0+, DB2 for z/OS 8.1+, Progress 8.0+, DB2 for i 4.0+
Long_IdAll
NameAll
Name_QualifierAll
Note_ListAll
Object_GUIDAll
Oracle_Database_Link_RefOracle 8.0+
Oracle_Is_Public_SynonymOracle 8.0+
Owner_PathAll
Remote_Object_NameOracle 8.1+, SQL Server 9.0+, SQL Azure 10.0+
Remote_Object_OwnerOracle 8.1+
Schema_NameInformix 7.0+, ODBC 2.0+, Oracle 8.0+, Progress 9.0+, SAS 1.0+, SQL Server 8.0-8.0, Sybase 12.5+, DB2 for i 4.0+, Sybase IQ 12.5+, MySQL 5.0+
Schema_RefDB2 for LUW 9.1+, DB2 for z/OS 8.1+, SQL Server 9.0+, SQL Azure 10.0+
Use_Replace_SyntaxDB2 for LUW 9.7+, Oracle 8.1+
User_Formatted_NameAll
User_Formatted_Physical_NameAll