kayamboo,
Thursday, October 10, 2002, 3:25:38 AM, you wrote:
k> If suppose my table has thousands of records, is it possible to create a
k> new table without a foreign key constraint, and then copy the existing data
k> with the foreign key constraint to the new one ?
Sure.
--
For technical
>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 9:15 PM
Subject: re: drop constraint in innodb
> kayamboo,
> Wednesday, October 09, 2002, 8:45:39 AM, you wrote:
>
> k> ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
> k> Syoyu_db( Code,
Is there any other way to do this in a table with thousands of records.
- Original Message -
From: "Heo, Jungsu" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 8:50 PM
Subject: Re: d
kayamboo,
Wednesday, October 09, 2002, 8:45:39 AM, you wrote:
k> ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
k> Syoyu_db( Code, Kana) ON DELETE CASCADE ;
k> works fine.
k> But how to drop the constraint or modify the constraint ?
k> Simply changing ADD to DROP or MODI
ay, October 09, 2002 2:45 PM
Subject: drop constraint in innodb
> sql, query
>
>
> Hi Folks
>
> ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
> Syoyu_db( Code, Kana) ON DELETE CASCADE ;
>
> works fine.
>
> But how to drop the constraint or mo
sql, query
Hi Folks
ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
Syoyu_db( Code, Kana) ON DELETE CASCADE ;
works fine.
But how to drop the constraint or modify the constraint ?
Simply changing ADD to DROP or MODIFY throws errors
regards
--
