Is is possible to modify computed columns?

Help
1

Hi,
I have created a table with computed column, and data is already inserted into the table.
Is it possible to change the formula of the computed field ?

Thanks
Karthikeya

2

Hi,

We don’t support ALTER TABLE MODIFY COLUMN of a computed column. We are tracking this as feature request for a future release.

I think the best approach to do this today is to:

ALTER TABLE <tab> DROP COLUMN <computed_column>;
ALTER TABLE <tab> ADD COLUMN <computed_columns> as <new expressions>;