On 10-5-2011 9:17, Olaf Kluge wrote:

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

Your co-worker quoted the identifiers, which means that select ... from
tablename won't work, while select ... from "tablename" will work. This
is basic and documented Firebird behavior

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

First it isn't a problem. If an identifier is quoted during creation it
is case-sensitive. Unquoted identifiers are technically
case-insensitive, but treated as though they are uppercase. so an
identifier tablename does not match "tablename".

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

Quote the identifier in your statements.

Mark

--
Mark Rotteveel