I'm trying to create a set of tables, some of which have a foreign key
pointing to other tables in the same set. The problem arises when it
tries to add a table before the table it depends on has been created. Is
there any way to defer the checking of foreign key dependancies until
after the whole transaction block?
Alternately, would I be better off creating the tables with no foreign
keys, and issuing alter statements at the end to add the keys? Thanks!
Daniel