Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ SQL Reference/ SQL Syntax/ D/ DROP SYNONYM
Updated on 2024-06-03 GMT+08:00
View PDF
Share

DROP SYNONYM

Description

Deletes a synonym.

Precautions

Only the synonym owner or a user granted with the DROP ANY SYNONYM permission can run the DROP SYNONYM command. System administrators have 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

Parent topic: D