Synonym of DB2 Table

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. ; ; ; ;