Re: Removing public synonym

From: Gregg Sporar <gregg_sporar_at_i2.com>
Date: 1997/12/19
Message-ID: <349A9DFD.469A@i2.com>#1/1

DROP PUBLIC SYNONYM syn

should do what you want

HTH, Gregg Sporar
i2 Technologies

Michael Urtheil 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
Received on Fri Dec 19 1997 - 00:00:00 CST