Re: How to disable foreign key constraints in a stored procedure?

On Fri, 17 Mar 2006 05:47:30 -0800, laredotornado wrote:

> Your suggestions are apprecaited, - Dave

My suggestion is: change the design. If you don't need foreign keys, drop them. If you do need them, then leave them in place. If you want to add child records before the parent records, that's what you have deferred constraints for. If you don't know how to do it, great, it's a wrong thing to do anyway.

-- 
http://www.mgogala.com