is it possible to alter a column name?

[lhugh]

I would like to alter a column name of my table. Is it possible to do it?

 

[bastienk]

yes....posted just yesterday

ALTER TABLE t1 CHANGE a b COLUMN SETTINGS;
--> eg.

Alter table tester change Blah blah VARCHAR(10);

Bastien

Cat, the other other white meat

 

[lhugh]

thanks