Oracle-L: Re: how to drop table named with caps off

From: Srinivas CH <chsrini_at_TC4HQ.CMC.STPH.NET>
Date: Mon, 5 Feb 1996 21:07:10 -0500
Message-Id: <9602051552.AA00735@alice.jcc.com>

Hi,

Use the following command at SQL Prompt

drop table "junk";

Dont forget to put the table name in double quotes.

--Ch. Srinivas
  DBA
  CMC Limited
  Hyderabad
  INDIA   Email : chsrini_at_tc4hq.cmc.stph.net

>
> Hi all,
>
> I created a table and inadvertently named it 'junk' instead of 'JUNK'. Now
> I can't drop it. Does anyone have a solution for me other than recreating
> the schema without it?
>
> Thanks, Marta
>
Received on Mon Feb 05 1996 - 10:52:51 CST