ALTER TABLE table_name SET UNUSED (column_name)
can be used to mark a column to be dropped later. But can the column be unset also so that it can be used later when u think it is needed or not to be dropped? IS there a way out?
Printable View
ALTER TABLE table_name SET UNUSED (column_name)
can be used to mark a column to be dropped later. But can the column be unset also so that it can be used later when u think it is needed or not to be dropped? IS there a way out?
old backup file or export/import backup file only.
Once a column is dropped or the UNUSED flag is set, it is not possible to rollback the operation.