开发者

Deleting range partition in db2

I have a db2 table which was originally created with range partitioning on two of t开发者_高级运维he columns, but now I feel it unnecessary to have the range partitioning. How do I remove range partitioning from the table without deleting the data already present in it.


I'm afraid you can't do that (other than creating a new table without the partitions and copying all the data over there - this can be tricky if you have foreign key constraints...).

This is one of those DB2 concepts where you have to decide what you want at creation time.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜