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 ;