Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : DROP SYNONYM
 

DROP SYNONYM

Drops the specified synonym.

Syntax

DROP [ PUBLIC ] SYNONYM synonym ;

Parameters

PUBLIC
Specifies that the synonym was created with the PUBLIC argument.
SYNONYM synonym
Name for the synonym.

Notes

*If DROP SYNONYM specifies PUBLIC and the synonym was not a public synonym, SQL generates the "base table not found" error.
*If DROP SYNONYM does not specify PUBLIC and the synonym was created with the PUBLIC argument, SQL generates the "base table not found" error.

Example

The following is an example of the DROP SYNONYM statement:
DROP SYNONYM customer ;
DROP PUBLIC SYNONYM public_suppliers ;
* Authorization
* Related statement