Hi, I am using informix 9.4, I am able to create a new table with column name as "type", I want add a new column as "type char(1)" in the existing table. I tried this using alter table query, but it is not allowing me to alter it. But in informix 7.3 I am able to add new column as "type" using alter table query. if anyone knows the reason please share with me.

Thanks
Sarwan

It'd be nice if you posted your full sql, but I'm guessing you don't need the 'type' keyword.

eg.

alter table dropme add ( hello char(1) );

should work.

You can't use "type" as a column name because "type" is a reserved word.