Drops a synonym definition.

1  –  Environment

    You can use the DROP SYNONYM statement:

    o  In interactive SQL

    o  Embedded in host language programs

    o  As part of a procedure in an SQL module or other compound
       statement

    o  In dynamic SQL as a statement to be dynamically executed

2  –  Format

  DROP -+-----------+-> SYNONYM <synonym-name> -+-+---------------+-+->
        +-> PUBLIC -+                           | +-> CASCADE  ---+ |
                                                | +-> RESTRICT ---+ |
                                                | +-> IF EXISTS --+ |
                                                +---------<---------+

3  –  Arguments

3.1  –  CASCADE

    Specifies that you want SQL to delete the synonym definition even
    if other database objects reference this name. This might later
    cause errors when executing queries. Stored functions, stored
    procedures, and triggers that reference this name will be marked
    as invalid.

3.2  –  IF_EXISTS

    Prevents SQL command language from displaying error messages if
    the referenced object does not exist in the database.

3.3  –  PUBLIC

    This optional clause is provided for compatibility with the
    Oracle database server. It is currently not used by Oracle
    Rdb. Its presence or absence may be used by future releases.
    Oracle Corporation recommends you use the PUBLIC keyword in
    applications.

3.4  –  RESTRICT

    Specifies that you want SQL to abort the DROP statement if it
    detects any database object referencing this name. This is the
    default.

3.5  –  synonym-name

    The name of an existing synonym you want to drop.

4  –  Example

    Example 1: Dropping a Synonym

    SQL> DROP PUBLIC SYNONYM employees CASCADE;