Follow Martijn's instructions, making sure you quote all names "..." not
'...'. If you can't do it with your existing tools you can always do it
with isql (in the Firebird_2_5/bin folder) or FlameRobin
(www.flamerobin.org, free, multiplatform and open source like FB itself).

Kjell

Den 2011-05-10 09:17 skrev Olaf Kluge såhär:

>
>
> Hello,
>
> 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@...
> <mailto:olaf.kluge%40satron.de>> olaf.kluge@...
> <mailto:olaf.kluge%40satron.de>
> 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]
>
>

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64