On Thu, Jul 22, 2010 at 8:47 AM, John Daisley <daisleyj...@googlemail.com>wrote:
> Most likely a foreign key constraint would be violated if the table were > dropped. Check those index definitions on `Store` and `User` columns. > But I don't want to drop the table, I want to drop the foreign key on Store. How? TIA, V > > Regards > > John Daisley > > Microsoft SQL Server 2005/2008 Database Administrator > Certified MySQL 5 Database Administrator > Certified MySQL 5 Developer > Cognos BI Developer > > Telephone: +44 (0)7918 621621 > Email: john.dais...@butterflysystems.co.uk > > On 22 July 2010 14:02, Victor Subervi <victorsube...@gmail.com> wrote: > >> Hi; >> >> mysql> alter table personalData drop foreign key Store; >> ERROR 1025 (HY000): Error on rename of './test/personalData' to >> './test/#sql2-14ce-a61' (errno: 152) >> mysql> describe personalData; >> >> +-------------------+------------------+------+-----+------------+----------------+ >> | Field | Type | Null | Key | Default | >> Extra | >> >> +-------------------+------------------+------+-----+------------+----------------+ >> | ID | int(10) unsigned | NO | PRI | NULL | >> auto_increment | >> | Store | varchar(40) | NO | MUL | NULL >> | | >> | User | varchar(50) | NO | MUL | NULL >> | | >> | FirstName | varchar(100) | NO | | NULL >> | | >> | LastName | varchar(100) | NO | | NULL >> | | >> | Phone | varchar(13) | YES | | NULL >> | | >> | Cell | varchar(13) | YES | | NULL >> | | >> | Fax | varchar(13) | YES | | NULL >> | | >> | AddressID | int(11) | YES | | NULL >> | | >> | ShippingAddressID | int(11) | YES | | NULL >> | | >> | DOB | date | YES | | 2000-01-01 >> | | >> | Email | varchar(100) | NO | | NULL >> | | >> | PW | varchar(12) | NO | | NULL >> | | >> >> +-------------------+------------------+------+-----+------------+----------------+ >> 13 rows in set (0.00 sec) >> >> How drop it? >> TIA, >> Victor >> > > > > -- > John Daisley > > Certified MySQL 5 Database Administrator > Certified MySQL 5 Developer > Cognos BI Developer > > Telephone: +44 (0)7918 621621 > Email: john.dais...@butterflysystems.co.uk >