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
