Updated on 2022-06-11 GMT+08:00

DROP SYNONYM

Function

DROP SYNONYM is used to delete a synonym object.

Precautions

Only a synonym owner or a system administrator can run the DROP SYNONYM command.

Syntax

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

Parameter Description

  • IF EXISTS

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

  • synonym_name

    Name of a synonym (optionally with schema names)

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

Examples

Delete a synonym.

1
2
DROP SYNONYM t1;
DROP SCHEMA ot CASCADE;

Helpful Links

ALTER SYNONYM and CREATE SYNONYM