DROP SYNONYM

Use the DROP SYNONYM command to drop a synonym.

Syntax

Syntax for dropping a synonym:

DROP SYNONYM <synonym>

Input

The DROP SYNONYM command takes the following input:

Table 1. DROP SYNONYM input
Input	Description
<synonym>	The name of the synonym to be dropped.

Output

The DROP SYNONYM command produces the following output:

Table 2. DROP SYNONYM output
Output	Description
`DROP SYNONYM`	The command was successful.

Privileges

You must be the admin user, the synonym owner, the owner of the database or schema where the synonym is defined, or your account must have the Drop privilege for thesynonym or for the Synonym object class.

Usage

The following provides sample usage:

Drop the synonym pr:
```
MYDB.SCH1(USER)=> DROP SYNONYM pr;
```