Title: What is the difference between dropping a column with the DROP COLUMN clause and setting a column as ... Post by: kekule on Jan 31, 2018 What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?
Title: What is the difference between dropping a column with the DROP COLUMN clause and setting a column as ... Post by: pianoman314 on Jan 31, 2018 When a column is dropped with the DROP COLUMN clause, the storage space occupied by the data is freed up immediately. However, with the SET UNUSED clause, the column is unavailable, but the storage space it occupies is not released until the DROP UNUSED COLUMNS clause is executed.
|