Query for dropping a PPI column

Database
MBR
Enthusiast

Query for dropping a PPI column

Hi All,

Anybody tell me the query for dropping a PPI column in table.

Thaks in advance

Regards

3 REPLIES
Enthusiast

Re: Query for dropping a PPI column

ALTER TABLE..

MODIFY PRIMARY INDEX

DROP RANGE BETWEEN...

MBR
Enthusiast

Re: Query for dropping a PPI column

Thanks KS for replying

above query is for altering a ppi right?

but i want to drop that column permanently, how can we do that?

Regards

Enthusiast

Re: Query for dropping a PPI column

Ok, got your issue now. As you can't drop the column on which you have partitions, so you need to delete the partitions first. But I don't think you can remove all the partitions. So, I guess the best way is to drop the table by taking backup of data and recreate without that column and insert data again from the backup table. Thought about it alot, but not sure if there is any better way. Let me know if you find any different solution.