Aliases are used to give some meaningful (alternate) names to the existing DB2 tables. These can refer tables which are local to the system as well as those which are remote. If a table is dropped then the associated aliases are not dropped on their own. How to Create an Alias on a DB2 Table?
CREATE ALIAS alias_name FOR Table_Name
Where alias_name is the alternate name (alias) you want to create on the table. and Table_name is the name of the table on which alias is created. ; ; ; ;