Biology Forums - Study Force

Other Fields Homework Help Management Topic started by: kekule on Jan 31, 2018



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.