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


© Copyright SS64.com 1999-2014
Some rights reserved