All Forums Database
MBR 29 posts Joined 01/13
25 Mar 2013
Query for dropping a PPI column

Hi All,
Anybody tell me the query for dropping a PPI column in table.
Thaks in advance
 
Regards
 

Bala
KS42982 137 posts Joined 12/12
25 Mar 2013

ALTER TABLE..
MODIFY PRIMARY INDEX
DROP RANGE BETWEEN...

MBR 29 posts Joined 01/13
25 Mar 2013

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
 
 
 
 

Bala

KS42982 137 posts Joined 12/12
26 Mar 2013

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.

You must sign in to leave a comment.