Thanks for the suggestions.
It worked fine
regards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 11:36 PM
Subject: re: Re: alter table syntax
> kayamb
kayamboo,
Friday, December 06, 2002, 9:15:04 AM, you wrote:
k> When I tried to drop the key, this was the error
k> mysql> alter table town_db drop primary key ;
k> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db'
k> (errno: 150)
k> I suppose some lock in the index somew
