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
  • 9,194
  • 6
  • 42
  • 68

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
  • 16,128
  • 3
  • 32
  • 56
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
  • 18,436
  • 13
  • 66
  • 75