Unsupported Screen Size: The viewport size is too small for the theme to render properly.

cannot delete foreign keys

forums › forums › SQLyog › Using SQLyog › cannot delete foreign keys

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • September 28, 2004 at 3:23 pm #8589
      [email protected]
      Member

      Having now updated to ver 4 so that I can see the FK detail. I now find that I have included some incorrect or duplicate information from when I couldn't see the FK details. However, when I try to delete this information I get the error:

      Error 1283 column “****” cannot be part of Full text index

      or

      Error 1064 you have an error in you SQL syntax

      Regards

      Richard

    • September 28, 2004 at 3:44 pm #16333
      Ritesh
      Member

      Are you trying to delete a FK?

      Can you send us the CREATE TABLE… stmts. for your tables so that we can work on it out here and resolve the bugs (if there are any)?

    • September 28, 2004 at 10:02 pm #16334
      Shadow
      Member

      Are you trying to delete “duplicate information” via your own SQL statements or via SQLyog's GUI? The first error you described happens if you want to create fulltext index on any column in an InnoDB table.

    • October 3, 2004 at 5:16 am #16335
      [email protected]
      Member

      I have deleted the database and have reimported it to start again now that this bug has been fixed

      Regards

      Richard

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.