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 Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/94964-deleting-an-index/#findComment-488478 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.