Alter Table Make Computed Column

View All Public Scripts Login to Run Script

Script Name Alter Table Make Computed Column
Visibility Unlisted - anyone with the share link can access
Description Do an Alter table to change an existing Integer column to be a computed column. It appears that this is not allowed, but I cannot find documentation that specifies its behaviour.
Area SQL General
Contributor aubrey.eichel@optum.com
Created Thursday March 04, 2021

Statement 2

Create table t1 
    (c1 Int Default 0 Not Null, 
     c2 Int Default 0 Not Null)

Table created.

Statement 3

Alter table t1 
    Modify c2 as (c1 + 1)

ORA-54026: Real column cannot have an expression

Additional Information