Re: Deleting foreign keys with Innodb tables

2002-07-18 Thread Heikki Tuuri
Philip, - Original Message - From: "Philip Molter" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, July 18, 2002 6:23 PM Subject: Re: Deleting foreign keys with Innodb tables > On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko

Re: Deleting foreign keys with Innodb tables

2002-07-18 Thread Philip Molter
On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko wrote: : Archbold, : Thursday, July 18, 2002, 12:18:09 AM, you wrote: : : A> I'm having a problem dropping a foreign key constraint from an Innodb table. I am :using MySQL 3.23.51 for Win32. Any help would be greatly appreciated

Re: Deleting foreign keys with Innodb tables

2002-07-18 Thread Victoria Reznichenko
Archbold, Thursday, July 18, 2002, 12:18:09 AM, you wrote: A> I'm having a problem dropping a foreign key constraint from an Innodb table. I am using MySQL 3.23.51 for Win32. Any help would be greatly appreciated A> I have a simple set up like the one below: A> CREATE TABLE mastertable A

Deleting foreign keys with Innodb tables

2002-07-17 Thread Archbold, David W.
Hi, I'm having a problem dropping a foreign key constraint from an Innodb table. I am using MySQL 3.23.51 for Win32. Any help would be greatly appreciated I have a simple set up like the one below: CREATE TABLE mastertable ( masterkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT ) TYPE=innodb