So it's not a problem to drop and recreate the FOREIGN KEYs?
And can I use START TRANSACTION while doing it?
On Fri, Apr 27, 2012 at 9:30 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> On 27/04/2012 19:59, Alexander Farber wrote:
>> in 8.4.9 is it please possible to add "on delete cascades" to
>> the both foreign keys in the following table w/o dropping the table?
>
> I think you will have to drop the foreign key and re-create it, but
> certainly not the table.