Dropping Synonyms

To drop a synonym, use either the SQL Developer navigation frame and Drop tool, or the DDL statement DROP SYNONYM.

Caution: Do not drop the synonym that you created in "Creating Synonyms"—you need it for later tutorials. If you want to practice dropping sequences, create new ones and then drop them.

To drop a synonym using the Drop tool:

On the Connections tab, expand hr_conn.

Under the hr_conn icon, a list of schema object types appears.
Expand Synonyms.

A list of synonyms appears.
Right-click the name of the synonym to drop.

A list of choices appears.
Click Drop.

The Drop window opens.
Click Apply.

The Confirmation window opens.
Click OK.

Dropping Synonyms

Related Topics