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

A synonym is created by a .

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

Syntax DROP SYNONYM synonymName