Db2 removal of Generate always Expression on Timestamp data type

db2

I have a column UPDATE_TIME with an expression 

 TIMESTAMP NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP

How to remove the Generated always for timestamps?

I tried 

  db2 "alter table xxxx alter column UPDATE_TIME drop expression"

Best Answer

This is not valid syntax. You need to use,

 alter table xxxx alter column update_time drop generated

See the documentation on alter table for more details.

Related Question