Re: Removing public synonym

From: Nimrod Oren <nimrodo_at_hotmail.com>
Date: 1997/12/22
Message-ID: <349e2c11.5681886@news.netvision.net.il>#1/1

On Fri, 19 Dec 1997 08:38:18 -0500, Michael Urtheil <murtheil_at_novadata.com> wrote:

>I created a number of public synonyms which I would now like to delete
>or remove (the synonym name only), but I can't find any references that
>help me with the opposite command of CREATE PUBLIC SYNONYM. I am
>relatively new to SQL and know how to remove the public synonyms from
>the schema manager, but want to include this in an SQL script that I can
>run instead.
>
>Thanks.
>
>Michael Urtheil
>

The command is:
DROP PUBLIC SYNONYM ...
Make sure you have the GRANT to drop them.

Nimrod Oren
nimrodo_at_hotmail.com Received on Mon Dec 22 1997 - 00:00:00 CST