Re: Declaring Unenforced Constraints

From: Laconic2 <laconic2_at_comcast.net>
Date: Fri, 5 Nov 2004 14:31:28 -0500
Message-ID: <yrudnS4h2tqFSBbcRVn-jg@comcast.com>

"Paul" <paul_at_test.com> wrote in message
news:418bd2af$0$524$ed2619ec_at_ptn-nntp-reader03.plus.net...

> SQL Server has this as well, at least for foreign keys.
>
> It can be useful if you're loading in a massive amount of data from an
> online system to a reporting system and you don't want to worry about
> having to load the tables in a specific order or to have the whole thing
> crash at the start due to a small broken key constraint.

Thanks to you and to Tony for bringing me up to date on SQL Server and Oracle. How about DB2, anyone?

> Once the data's in you can enable the constraints and make sure the data
> is all valid. If it's not, you've got the data at hand to investigate
> the problem easily.

This is exactly what I was driving at. Thanks. Received on Fri Nov 05 2004 - 13:31:28 CST