Synonym of DB2 Table
SYNONYM OF A DB2 TABLE
What is a Synonym?
Synonyms are used to give some meaningful (alternate) names to the existing tables.
These can refer tables which are local to the system, these can not access the remote
tables. If a table is dropped then all the associated synonyms are dropped automatically.
How to Create Synonym on a DB2 Table?
CREATE SYNONYM synonym_name FOR Table_Name
Where synonym_name is the alternate name (Synonym) you want to create on the table.
and Table_name is the name of the table on which synonym is created.; ; ; ;