How can I change a column's name?

Submitted by huangke2006 on Sun, 2008-11-09 10:43

Can I use the
ALTER TABLE TableName RENAME COLUMN FieldName TO FieldName1 ?
or other method can work fine.

thanks...

‹ How to create a different instacne and how to initalize these different instances Informix one-click-install on Ubuntu ›

This command changes the name

Submitted by lastinfoer on Sun, 2009-05-24 13:39.

This command changes the name of a column.

RENAME COLUMN table_name.old_column_name TO new_column_name

eg. rename column cust.cust_no to cust_number;

--------------------
database management

rename column

Submitted by eherber on Mon, 2008-11-10 15:15.

The syntax is:

rename table.old_colname to new_colname

You can check the online documentation here:

IDS 11.5: RENAME COLUMN

HTH.