How to ALTER COLUMN using AS

Asked Dec 06 '21 at 13:37

Active Dec 06 '21 at 13:37

Viewed 46 times

I've got a question about column modification. I would like to change column content.

I cannot use the UPDATE command, because the most important thing is that the column changes, in case of changes in the columns from which this one is concatenated. I have used code below

ALTER TABLE test_table
ALTER COLUMN col4 AS CONCAT(col1, ABS(col2), TRIM(col3))

Is it possible to define an existing column in this way? In my case, I have to make sucha an operation on primary key column so I would prefer not to delete this one and ADD new.

I will be grateful for any tip

asked Dec 06 '21 at 13:37

Mateusz Klencz

2

You cannot `ALTER` a computed column. You must `DROP` and re-`ADD` it. – Thom A Dec 06 '21 at 13:39
Oh, I understand. Thank you very much – Mateusz Klencz Dec 06 '21 at 13:42

How to ALTER COLUMN using AS

0 Answers0