MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:March 3 2004 2:30pm
Subject:Re: Changing the primary key
View as plain text  
"Ranetbauer, Michael" <Michael.Ranetbauer@stripped> wrote:
> Hi!
> 
> At first thanks for your help.
> 
> Now I can change the PRIMARY KEY of the table, but now I have a new
> question:
> 
> How can I change the FOREIGN KEYS?
> 

You can drop old FOREIGN KEY with ALTER TABLE .. DROP FOREIGN KEY statement:
	http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html

Then create a new one.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




Thread
Changing the primary keyMichael Ranetbauer3 Mar
  • Re: Changing the primary keyRichard Davey3 Mar
    • RE: Changing the primary keyBoyd E. Hemphill3 Mar
  • Re: Changing the primary keyAlec.Cawley3 Mar
AW: Changing the primary keyMichael Ranetbauer3 Mar
  • Re: Changing the primary keyVictoria Reznichenko3 Mar
AW: Changing the primary keyMichael Ranetbauer3 Mar
  • Re: Changing the primary keyVictoria Reznichenko3 Mar
Re: Changing the primary keyDaniel Clark4 Mar