disable and enable tables relations

[ahmed ghaly]

my question is there any way to disable relations between
a table (products) and all related tables in the system to
do some data change then.
enable the relations back
ex :
disable all constraints
enable all constraints

thanks for any help

 

[John Vinson]

my question is there any way to disable relations between
a table (products) and all related tables in the system to
do some data change then.
enable the relations back
ex :
disable all constraints
enable all constraints

thanks for any help

ummm...

WHY?

The constraints are there for a reason. Using appropriate settings of
Cascade Deletes and Cascade Updates, and (if necessary) setting the
properties of a form to allow inconsistent updates, it should never be
necessary to remove and add relationships.

You can do it with some fairly nitpicky DAO code, but it will be a
very expensive operation, both in time and database bloat, since
removing a relationship involves deleting the indexes on the joining
fields, and recreating a relationship rebuilds those same indexes.