× Didn't find what you were looking for? Ask a question
  
  
Top Posters
Since Sunday
p
68
65
C
18
I
13
n
13
a
12
12
11
C
11
s
11
11
m
11
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 21 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
  91 People Browsing
Related Images
 98
 19
 33