Table and column aliases

Aliases are like synonyms in that they are another name for tables or columns. Aliases differ from synonyms in that they exist only during the query.

Aliases can be single letters or words, but when you are using aliases in cross-database access, the system expects the column name to be in the form of the alias.column-name.

For example, the following are correct notations, where E is the alias:

dev.sch1(admin)=> FROM emp E WHERE E.id =10
dev.sch1(admin)=> FROM admin.emp E WHERE E.id =10