Breaking a Relationship

[Kjonnnn]

Im trying to fix a database that someone else created. If I break the relationships between the tables (3) and recreate them, does that screw up the data?

 

[WildHare]

Ordinarily, no it should not. A lot depends, however, on what you do in between the "break" and the "re-create". If, for example, you introduce duplicate data into a table, or delete certain records in other tables or change key structures, you might NOT be able to recreate the relations with other tables, due to referential integrity constraints et cetera.

Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com