Hi, first of all I'm sorry for my bad English but I'm Italian.
I've a table X with a reference key to the id of another table A. For bakup motivation, every two days I've to move the data from table A to another identical table but named B. If I'm doing this, I've the problem that the table x no more find the entries in the table A and consequently return a reference error.
The provisional solution that I've found it's to remove the foreign key from the table X. Can you advise a better solution?
Thanks