Creating and managing synonyms

A synonym is an alternative name for the table or view. A synonym provides data independence and location transparency. The following is an example of the CREATE SYNONYM statement:

-- Create a new synonym
CREATE SYNONYM emp_syn FOR emp;

Now we can query the emp table directly or using the new emp_syn synonym.

To remove the synonym from the schema, we use the DROP SYNONYM command as follows:

-- Permanently remove the synonym from the database
DROP SYNONYM emp_syn;