taz321 Posted March 7, 2008 Share Posted March 7, 2008 Hi I have installed on my computer php myadmin which came with the wampserver i downloaded I have a table called Form and within that table i have the record called EmployeeID which is a foreign key from the employee table. This has been set to Index for some reason, i now to delete this record (or drop it )but i get this error - SQL query: ALTER TABLE `form` DROP INDEX `employeeID` MySQL said: #1025 - Error on rename of '.\helpdesk\#sql-90c_91' to '.\helpdesk\form' (errno: 150) Can anyone shed some light on this Thanks Link to comment https://forums.phpfreaks.com/topic/94964-deleting-an-index/ Share on other sites More sharing options...
taz321 Posted March 8, 2008 Author Share Posted March 8, 2008 Does anyone have an reply to this ? Thanks Link to comment https://forums.phpfreaks.com/topic/94964-deleting-an-index/#findComment-486878 Share on other sites More sharing options...
fenway Posted March 10, 2008 Share Posted March 10, 2008 See here -- sounds like to have to fix the FK issue first. Link to comment https://forums.phpfreaks.com/topic/94964-deleting-an-index/#findComment-488478 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.