From: Dan Nelson
Date: December 9 2002 1:06am
Subject: Re: alter table syntax
List-Archive: http://lists.mysql.com/mysql/126961
Message-Id: <20021209010642.GA97118@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Dec 09), kayamboo said:
> 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>

The alter table failed because of error 150.  Run the command "perror 150"
at your shell prompt (not the mysql prompt) to find out why the
command failed.

-- 
	Dan Nelson
	dnelson@stripped