Home Oracle Commands

DROP SYNONYM

Delete a synonym.

Syntax:

   DROP [PUBLIC] SYNONYM [schema.]synonym [FORCE]


FORCE will drop the synonym even there are dependent tables or user-defined types.

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

Related Commands:

CREATE SYNONYM
DROP VIEW

Related Views:

 DBA_SYNONYMS         ALL_SYNONYMS         USER_SYNONYMS       PUBLICSYN



Back to the Top

Simon Sheppard
SS64.com