Most likely a foreign key constraint would be violated if the table were dropped. Check those index definitions on `Store` and `User` columns.
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
