CODEWITHSUNDEEP
sqldb2
SHAHZZ
SHAHZZ

Reputation: 121

How to change the column name in DB2

I need to rename the column name of one of the table. I have DB2 database and we are connecting with the database and executing sql queries through Eclipse IDE.

Thanks.

Upvotes: 11

Views: 37476

Answers (1)

duffymo
duffymo

Reputation: 308753

Use an ALTER TABLE statement.

ALTER TABLE G31.TG31PDIX RENAME COLUMN RECORD_KEY TO RECORD_KEYY;

This will only work if you use a version of DB2 that supports this feature. An older version might be out of luck. I'm not sure when they added it, but it was after 2004.

Upvotes: 14

Related Questions