2

Is there a setting in derby, for example an sql query ala "SET DATABASE REFERENTIAL INTEGRITY FALSE" where i can turn on and off referential integrity?

netbrain
  • 8,994
  • 6
  • 39
  • 67

2 Answers2

2

If you have a constraint that you don't wish to enforce, you can use DROP CONSTRAINT to drop it.

I frequently drop a constraint for a period of time while I am re-structuring my database, then re-add the constraint subsequently when I have the new data arranged as I want it.

Bryan Pendleton
  • 15,759
  • 3
  • 31
  • 51
1

According to this post on the mailing list (from 2006) it is not possible:

http://www.mail-archive.com/derby-user@db.apache.org/msg05345.html

I couldn't find anything in the manual either.

And the list of jdbc parameters has nothing, too.

oers
  • 17,930
  • 13
  • 65
  • 74