AW: Changing the primary key

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? Best regards Michael R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

AW: Changing the primary key

Hi Richard At first, thank you for your answer. I've tried your solution, but when I try to drop the PRIMARY KEY I get following error: [localhost] ERROR 1025: Error on rename of '.\austro\#sql-280_110' to '.\austro\fluege' (errno: 150) Best regards Michael R. -- MySQL General Mailing List F