Re: Declaring Unenforced Constraints
Date: Fri, 5 Nov 2004 14:31:28 -0500
Message-ID: <yrudnS4h2tqFSBbcRVn-jg_at_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.
Thanks to you and to Tony for bringing me up to date on SQL Server and
Oracle. How about DB2, anyone?
>
> 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.
> 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 - 20:31:28 CET