truncate a table ignoring relations

[chathura86]

hi,
i have a table which has child rows in another table. Now i want to truncate this
table temporally, because i will re-enter those values in a short time with some changes. cannot use update statement to make those changes. only possible way is truncating and inserting.

also i want to insert some data in to child rows without any parent rows. as in the previous section i can add the relevant parent rows shortly.

its like i want to ignore all the relations temporally while I’m performing this operation. After finishing it relations should work properly. it is 100% sure that the data is in the correct order to perform relations after i complete this operation.

Thank you,

Chathura Bamunusinghe

[amitpatel66]

hi,
i have a table which has child rows in another table. Now i want to truncate this
table temporally, because i will re-enter those values in a short time with some changes. cannot use update statement to make those changes. only possible way is truncating and inserting.

also i want to insert some data in to child rows without any parent rows. as in the previous section i can add the relevant parent rows shortly.

its like i want to ignore all the relations temporally while I’m performing this operation. After finishing it relations should work properly. it is 100% sure that the data is in the correct order to perform relations after i complete this operation.

Thank you,

Chathura Bamunusinghe

In case of primary key - foreign key relationship, you can disable the primary key of the table with CASCADE options. The cascase option will disable the refrential integrity constraints also. After disabling the constraints, you can perfomr TRUNCATE or DELETE/INSERT operations. Then you can ENABLE the constraints again

For disabling and enabling a constraint:

 
ALTER TABLE table_name DISABLE PRIMARY KEY CASCADE;
 
ALTER TABLE table_name ENABLE PRIMARY KEY;
 
 

[chathura86]

In case of primary key - foreign key relationship, you can disable the primary key of the table with CASCADE options. The cascase option will disable the refrential integrity constraints also. After disabling the constraints, you can perfomr TRUNCATE or DELETE/INSERT operations. Then you can ENABLE the constraints again

For disabling and enabling a constraint:

 
ALTER TABLE table_name DISABLE PRIMARY KEY CASCADE;
 
ALTER TABLE table_name ENABLE PRIMARY KEY;
 
 

it was a good solution,
thanks a lot.

chathura bamunusinghe

[amitpatel66]

it was a good solution,
thanks a lot.

chathura bamunusinghe

Hi,

You are Welcome!!
DO POST any issues in future, we will help you out!!

Regards,
Amit