Cannot delete a row and cannot find a table.
Posted by:
Edmund Uba
Date: December 02, 2014 05:11AM
Need help, I cannot delete a row, and I cannot even drop the table. I do not have a table named #sql-848_730 so I cannot drop it. Can anyone help me?
ERROR 1451: 1451: Cannot delete or update a parent row: a foreign key constraint fails (`dqm_crm`.`#sql-848_730`, CONSTRAINT `#sql-848_730_ibfk_2` FOREIGN KEY (`qCode`) REFERENCES `survey_details_qCode` (`qCode`))
SQL Statement:
UPDATE `dqm_crm`.`survey_details_qCode` SET `qCode`='60181' WHERE `qCode`='60180'
Subject
Written By
Posted
Cannot delete a row and cannot find a table.
December 02, 2014 05:11AM
December 02, 2014 07:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.