From: Dan Nelson Date: December 6 2002 5:19pm Subject: Re: alter table syntax List-Archive: http://lists.mysql.com/mysql/126832 Message-Id: <20021206171935.GD28777@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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