I'm not sure what exactly happened, but when I try to reproduce the problem now I cannot. As far as I can remember, I explicitly deleted the database files before running the test each time. Furthermore, I tried renaming the foreign keys by adding "2" to the name (which worked) and looking at the resulting table. I didn't see why a conflict was reported in the first place.
Anyway, I'll let you if I ever run into this problem again. You are probably right that something was not right in my test environment. Gili On Apr 9, 4:15 am, Thomas Mueller <[email protected]> wrote: > Hi, > > > How could the foreign key "fk_clinic_id" already exist in the above > > SQL statement? > > Most likely this foreign key existed _before_ running the above statement. > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
