Synonyms are useful for emulating operating system environment variables.

Just as you might assign 'sales' to be 'sales2016_q3.dat' at the OS level, you can do the equivalent in SQL by synonyms.

They...