Re: Need to get rid of a table with a mixed-case tablename
From: Anton Dischner <dischner_at_med.uni-meunchen.de>
Date: Wed, 22 Jun 1994 13:26:01 -0800
Message-ID: <dischner-220694132601_at_gkc12a.klch.med.uni-muenchen.de>
Date: Wed, 22 Jun 1994 13:26:01 -0800
Message-ID: <dischner-220694132601_at_gkc12a.klch.med.uni-muenchen.de>
In article <2te5nm$2ut$1_at_heifetz.msen.com>, jeffk_at_garnet.msen.com (Jeff Kopmanis) wrote:
>
> One of our people created a table with MS Access on our Oracle7 database
> (via ODBC) that has a name that is mixed-case. Oracle doesn't seem to want
> to touch it and MS Access doesn't let us do that via ODBC (that we can
> tell). How do you either override Access's foolishness or tell Oracle to
> NOT convert our SQL strings into upper case so that we may delete the
> table?
>
Try
drop table "Your_name";
instead of
drop table your_name;
I hope this helps,
Toni Received on Wed Jun 22 1994 - 23:26:01 CEST