"Ranetbauer, Michael" <[EMAIL PROTECTED]> wrote: > 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) >
$ perror 150 Error code 150: Unknown error 150 150 = Foreign key constraint is incorrectly formed You should create index on that column and then drop primary key. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
