I deleted some records in tables which are interconnected with other tables with foreign keys, so somehow I succeded to delete some records which I would not be able to delete (FK constraint). Now I cannot delete records in main tables (to which FK refers).
Anyway, I was trying to drop table, drop index, nothing helps. Is there any tool out there which will help repair tables? Tried with CHECK_TABLE, did not help.