RE: Triggers and Constraints
From: David Vazquez <dvazquez_at_msn.com>
Date: 1996/10/08
Message-ID: <00001a1b+00008bab_at_msn.com>#1/1
Date: 1996/10/08
Message-ID: <00001a1b+00008bab_at_msn.com>#1/1
Implement the constraints with alter tables instead of putting them in your create statements. I like to create my tables with only PKs, UKs, and checks. After the table is loaded with data, I then add the references and triggers ala alter table. If you know that your data is correct, you can postpone the PKs and UKs until after the table is loaded too to get better performance on the load.
Have fun.
-David Vazquez "dvazquez_at_msn.com"
Received on Tue Oct 08 1996 - 00:00:00 CEST