/SQL/Mysql remove foreign key constraint

Mysql remove foreign key constraint

Foreign key mySql

CREATE TABLE parent (
    id INT NOT NULL,
    PRIMARY KEY (id)
) ENGINE=INNODB;

CREATE TABLE child (
    id INT,
    parent_id INT,
    INDEX par_ind (parent_id),
    FOREIGN KEY (parent_id)
        REFERENCES parent(id)
        ON DELETE CASCADE
) ENGINE=INNODB;

Source: dev.mysql.com

Drop all foreign key constraints mysql

SET foreign_key_checks = 0;

Source: stackoverflow.com

Mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name

Drop foreign key mysql

ALTER TABLE table_name DROP FOREIGN KEY constraint_name

Source: tutorialspoint.com

Similar codes

0 vote324 views1 answer
Redirection 301 htaccess nom de domaine
SQL
21 votes96 views7 answers
Table drop if exist sql server
SQL
27 votes160 views5 answers
Mysql set password for user
SQL
1 vote147 views2 answers
Mysql error 1215
SQL
1 vote143 views1 answer
Mysql limit results to 10
SQL
0 vote148 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote150 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote121 views1 answer
Django how to get query result count
SQL
0 vote185 views1 answer
Sql ssrs
SQL
14 votes142 views3 answers
Oracle sql limit results
SQL