Hi Everyone,
I have a parent table P1(pid,name,rank) and child tables
C1(Cid,name,sal,PID), C2(Cid,name,sal,PID),
C3(Cid,name,sal,PID). P1 and C1,C2,C3 has foreign key relation.
Now I want to DROP the parent table P1 and Recreate by keeping the data in child tables and also the relation with the newly created table. Can somebody explain how can achieve it?