Re: can't drop sequence - name in lower case

Hi Jim,

You need to use quotes. Just type

drop sequence "seq_name";

Regards,
Paul

"Jim Lyons" <jlyons4435_at_my-deja.com> wrote in message news:8ma6nu$hl0$1_at_nnrp1.deja.com...
> I have inherited a sequence with the name of chat_room2_seq. It
> really is in lower case. I want to drop it and can't. I've tried in
> SQLPLUS and using a Perl script. I suspect the problem has to do
> with the lower case name.
>
> Can anyone tell how to get rid of the thing?
>
> Thanks
>
> --
> Jim Lyons | Network Systems Analyst
> Entertech - The IC2 Institute | 512-482-0273, ext. 269
> University of Texas at Austin | jlyons_at_weblyons.com
> http://www.weblyons.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 02 2000 - 00:00:00 CDT