Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ SQL Reference/ SQL Syntax/ DROP SYNONYM
Updated on 2023-10-23 GMT+08:00
View PDF
Share

DROP SYNONYM

Function

DROP SYNONYM deletes a synonym.

Precautions

Only the owner of a synonym or a system administrator has the DROP SYNONYM permission.

Syntax

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

Parameter Description

  • 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 CREATE SYNONYM.

Helpful Links

ALTER SYNONYM and CREATE SYNONYM

Parent topic: SQL Syntax