DROP SYNONYM statement

The DROP SYNONYM statement removes the specified synonym from a table or view.

A synonym is created by a CREATE SYNONYM statement.

An error will occur if there are any views or triggers dependent on the synonym.

Syntax

DROP SYNONYM synonymName
Parent topic: DROP statements
Related reference
DROP DERBY AGGREGATE statement
DROP FUNCTION statement
DROP INDEX statement
DROP PROCEDURE statement
DROP ROLE statement
DROP SCHEMA statement
DROP SEQUENCE statement
DROP TABLE statement
DROP TRIGGER statement
DROP TYPE statement
DROP VIEW statement