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

    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
    Location
    Toronto, Canada
    Posts
    20,002
    we had an entire thread on that topic just the other day

    check it out and let us know if you still have questions
    rudy.ca | @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
  •