Droping a Synonym
Using Synonyms
Creating and Using Database Objects 3-29
Click OK.
You created a synonym
positions
for the
jobs
table. The equivalent SQL statement
follows:
CREATE SYNONYM positions FOR jobs;
In
positions
synonym in place of the
jobs
table
name.
Example 38 Using a Synonym
SELECT first_name || ' ' || last_name "Name", p.job_title "Position"
FROM employees e, positions p
WHERE e.job_id = p.job_id
ORDER BY last_name;
The results of the query appear.
Name Position
--------------------- -------------------------
Ellen Abel Sales Representative
Sundar Ande Sales Representative
Mozhe Atkinson Stock Clerk
David Austin Programmer
...
197 rows selected
To drop a synonym:
Follow these steps to drop the
positions
synonym.
1.
In the Connections navigator, right-click the
positions
synonym.
2.
Select Drop.
