DROP SYNONYM

Description

Deletes a synonym.

Precautions

Only the synonym owner or a user granted with the DROP ANY SEQUENCE permission can run the DROP SYNONYM command. The system administrator has this permission by default.

Syntax

DROP [PUBLIC] SYNONYM [ IF EXISTS ] synonym_name [ CASCADE | RESTRICT ];

Parameters

• PUBLIC

  (Optional) Deletes PUBLIC synonyms.

• IF EXISTS

  Reports a notice instead of an error if the specified synonym does not exist.

• synonym_name

  Specifies the name (optionally schema-qualified) of the synonym to be deleted.

• CASCADE | RESTRICT
  • CASCADE: automatically deletes the objects (such as views) that depend on the synonym.
  • RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action.

Examples

See Examples in section "CREATE SYNONYM."

Helpful Links

ALTER SYNONYM and CREATE SYNONYM