I don't get you.
But when I executed the drop table syntax fromt he command line, the result
was this error
mysql> alter table town_db drop primary key ;
ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
(errno: 150)
mysql>
Can you make me clear?
regards
----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "kayamboo" <kayamboosuresh@stripped>
Cc: "list mysql" <mysql@stripped>; "R. Hannes Niedner"
<hannes.niedner@stripped>
Sent: Saturday, December 07, 2002 2:19 AM
Subject: Re: alter table syntax
> In the last episode (Dec 06), kayamboo said:
> > When I tried to drop the key, this was the error
> >
> > mysql> alter table town_db drop primary key ;
> > ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to
'.\forest\town_db' (errno: 150)
>
> And what does "perror 150" return (it's a shell command, not an SQL
> one)?
>
> --
> Dan Nelson
> dnelson@stripped
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread126832@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-kayamboosuresh=softhome.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
