Hello Olaf,

It appears that the tool you are using doesn't warn you about mixed
case names? Does it have a setting to automatically uppercase object
names?

Here's the deal:

create table MYTABLE
create table MyTable
create table mytable

all create a table MYTABLE that can be used in any case you like.

However, this:

create table "MYTABLE" result in any mytable
create table "MyTable" result in a table "MyTable" (with quotes!) only.
create table "mytable" results in a table "mytable" (with quotes!) only.

So the above statements create 3 tables mytable, but with different
cases because of the quotes!!

To remove the table, make sure to close all other connections (avoiding
"object in use"), drop foreign keys pointing to it, drop the table.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!




my co-worker has created a new table, unfortunately he named the fields with
lower case. Now, I can not read the columns with a sql-query and not delete
the table too.



How it Is ab problem If I named the tablefields in lowercase? I knew the
problem and have named the fields in upper case all the time and with older
versions of firebird.



We using firebird 2.5 cs and ems ib manager. Charset is iso8859_1.



How can I delete this table, especially the primary key? Currently I get the
error message "object index is in use" by deleting the field with primary
key and "object tablename is in use" by deleting the entire table.



Thank you very much.



Olaf



Mit freundlichen Grüßen / with best regards



Olaf Kluge



S A T R O N Sachsen
Steuerungstechnik GmbH
Johann-Gottlob-Pfaff Straße 7
D-09405 Zschopau




Tel: +49 (0) 3725 / 3506-31
Fax: +49 (0) 3725 / 3506-12
Mobil: +49 (0) 170 / 9292375
E-Mail: <blocked::mailto:olaf.kluge@...> olaf.kluge@...
Internet: <blocked::http://www.satron.de/> http://www.satron.de/


............................................................................
................
Geschäftsführer: Bernd Grötzschel, Gerd Kaden
Amtsgericht: Chemnitz HRB1218
Ust-ID-Nr: DE141294791



............................................................................
................
Diese E-Mail ist vertraulich. Wenn Sie nicht der beabsichtigte Empfänger
sind, dürfen Sie die Informationen nicht offen legen oder benutzen. Wenn Sie
diese E-Mail durch einen Fehler bekommen haben, teilen Sie uns dies bitte
mit, indem Sie die E-Mail an den Absender zurücksenden. Bitte löschen Sie
danach diese E-Mail.
This email is confidential. If you are not the intended recipient, you must
not disclose or use the information contained in it.
If you have received this mail in error, please tell us immediately by
return email and delete the document.



[Non-text portions of this message have been removed]



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links