Hi Slawek!

A wild guess: Maybe your table is defined case sensitive? If it is created like

CREATE TABLE Vehicles(Invoice_Date Date);

then it is case insensitive, the column name is stored in upper case and your alter statement should work. However, if it is created like this:

CREATE TABLE Vehicles("Invoice_Date" Date);

then it is case sensitive and you have to modify your alter statement to:

alter table VEHICLES alter column "Invoice_Date" to INVOICE_DATE_2; commit;

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Sławek Cabaj
Sent: 13. desember 2010 10:47
To: firebird-support
Subject: [firebird-support] Problem with renaming a column

Hello again,
One more, perhaps not complicated :) problem

When I want to change a column name

alter table VEHICLES alter column INVOICE_DATE to INVOICE_DATE_2; commit;

get

column INVOICE_DATE is not defined in table VEHICLES

But it is still there
I've recreated the database from a copy but it did not help :(
The table is empty.

??