Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## DROP SYNONYM

> Drops the specified synonym.

> #### Syntax

>     DROP [ PUBLIC ] SYNONYM synonym ;

> `PUBLIC`

> Specifies that the synonym was created with the `PUBLIC` argument.

> `SYNONYM synonym`

> Name for the synonym.

> Example

>     DROP SYNONYM customer ;
>     DROP PUBLIC SYNONYM public_suppliers ;

> #### 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.

> ##### Authorization

> Must have `DBA` privilege or ownership of the synonym (for `DROP SYNONYM`).

> ##### Related statements

> CREATE SYNONYM

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095