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

Thanks - I should have known that. It worked, of course, Jim

In article <bz1i5.9053$s04.1691474_at_typhoon-news1.southeast.rr.com>,   "Paul Druker" <pdruker_at_metaway.com> wrote:
> 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.
>
>

--
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.