Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Question on FOREIGN KEY CONSTRAINTS

    I've recently implemented a whole bunch of foreign key constraints in a database. As a result I have issues every time I want to truncate a table to perform data loads.

    Is there an easy way to tell the system to ignore these constraints for the term of a data load or truncation of data?

    thank you

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    we had an entire thread on that topic just the other day

    check it out and let us know if you still have questions | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts