HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

DROP SYNONYM

Function

DROP SYNONYM deletes a synonym.

Precautions

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

Syntax

DropSynonym ::= 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 Example in CREATE SYNONYM.

ALTER SYNONYM and CREATE SYNONYM

Copyright © 2011-2024 www.enmotech.com All rights reserved.