So is there no other way to do it but to verify the integrity using triggers and drop the referential constraints? Because I *still* need to verify that NEW records in the details table direct to something that exists > >> ON DELETE RESTRICT | NO ACTION won't let me delete the master >> CASCADE | SET NULL | SET DEFAULT will modify the details > > Can you just drop the constraint that's doing the referential integrity? > > Ray. > > Then remove the referential integrity constraint, since it's obviously > incompatible with your business requirements. > > -Doug _________________________________________________________________ Plug&Play te trae en exclusiva los mejores conciertos de la red http://club.prodigymsn.com/
