× Didn't find what you were looking for? Ask a question
  
  
Top Posters
Since Sunday
25
j
23
21
j
21
D
21
z
20
i
19
v
19
a
18
a
18
s
18
a
18
New Topic  
wrote...
Posts: 698
Rep: 0 0
A year ago
What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?
Read 18 times
1 Reply
Related Topics
Replies
wrote...
A year ago
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.
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  114 People Browsing
Your Opinion
Related Images
 138
 91
 176