Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    6

    Unanswered: HOW do I DROP a Constraint Foreign Key?

    According to the MySQL documentation, the ALTER TABLE DROP FOREIGN KEY internally_generated_foreign_key_id command will work from version 4.0.13.

    I have 4.0.12 :-(

    Is there a way to drop the constraint in 4.0.12.

    *** ALSO ***
    Again, according to the documentation:
    "Starting from version 3.23.50 InnoDB returns the foreign key definitions of a table when you call

    SHOW CREATE TABLE yourtablename"

    Well ... It doesn't do so with my 4.0.12 vesion!

    Any ideas on how I can determine the foreign key being used by a constraint?

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    With innodb table on mysql < 4.013 you simply alter the table (cange an index for example) and the foreign key will be drop
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    With innodb table on mysql < 4.013 you simply alter the table (cange an index for example) and the foreign key will be drop
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •