The SET UNUSED Option in ALTER TABLE

• You use the SET UNUSED option to mark one or more columns as unused.
• You use the DROP UNUSED COLUMNS option to remove the columns that are marked as unused.


ALTER TABLE table
SET UNUSED (column);
OR
ALTER TABLE table
SET UNUSED COLUMN column;


ALTER TABLE table
DROP UNUSED COLUMNS;