Should you EVER use the DROP COLUMN command?

Should you EVER use the DROP COLUMN command?

SQL and Database explained!

3 года назад

1,414 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@thomasgreska
@thomasgreska - 15.01.2021 17:14

I do not agree with you. There are reasons where you really need to drop the unused columns e.g. when you are using the EXCHANGE PARTITION feature - which won't work as long there are columns set to unused.
And I think it's really a gap in the product that the MOVE TABLE does not remove the unused colums. I do not know any "online" operation to get rid of these unused columns. And as you stated, doing it "offline" takes a while, esp. if you have a large table with hundrets of million records.

Ответить