DROP PUBLIC SYNONYM

3.3.33 DROP PUBLIC SYNONYM

Name

DROP PUBLIC SYNONYM -- remove a public synonym

Synopsis

DROP PUBLIC SYNONYM name

Description

DROP PUBLIC SYNONYM drops existing public synonyms. To execute this command you must be a superuser or the owner of the public synonym.

See Section 2.2.4 for additional information on public synonyms.

Parameters

name

The name of a public synonym to be removed

Examples

This command will remove the public synonym named, personnel:

DROP PUBLIC SYNONYM personnel;