DROP SYNONYM

Remove a synonym.

Syntax
      DROP SYNONYM [schema.]synonym

Key
   synonym    The synonym to be dropped

Synonyms may be dropped at any time e.g. with dynamic SQL.

Example

DROP SYNONYM MySyn;
GO

"A synonym is a word you use when you can't spell the word you first thought of" - Burt Bacharach

Related commands:

CREATE SYNONYM

Equivalent Oracle command:

DROP SYNONYM