CODEWITHSUNDEEP
db2rangedatabase-partitioning
Vivek
Vivek

Reputation: 2020

Deleting range partition in db2

I have a db2 table which was originally created with range partitioning on two of the 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.

Upvotes: 0

Views: 1273

Answers (1)

egbokul
egbokul

Reputation: 3974

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.

Upvotes: 1

Related Questions