Re: [SQL] ad hoc referential integrity

2003-07-14 Thread Stephan Szabo
On Tue, 15 Jul 2003, Matt Tenenbaum wrote: > Say I created a couple tables A and B, where A contains a column p > which B references as a foreign key. Further say that, when I created > these tables, I meant to specify 'on delete cascade' for p in the > definition of B but didn't. What's the prope

[SQL] ad hoc referential integrity

2003-07-14 Thread Matt Tenenbaum
At the outset I hope that this is the right place to ask this question (also, I hope the question isn't a foolish one). Say I created a couple tables A and B, where A contains a column p which B references as a foreign key. Further say that, when I created these tables, I meant to specify 'on d