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 Oracle Commands:

CREATE SYNONYM
DROP VIEW

Related Views:

 DBA_SYNONYMS         ALL_SYNONYMS         USER_SYNONYMS       PUBLICSYN


 
Copyright © SS64.com 1999-2019
Some rights reserved