/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 vote176 views2 answers
Update information in a mysql column
SQL
9 votes181 views3 answers
Mysql get last id
SQL
2 votes143 views1 answer
Sql group by different columns
SQL
1 vote193 views1 answer
How to unlock table in mysql
SQL
1 vote223 views1 answer
Difference between where and having clause
SQL
0 vote213 views1 answer
For row in sql database python loop
SQL
0 vote213 views1 answer
Query for backup a database at another location in file system
SQL
20 votes203 views5 answers
Reset auto increment mysql
SQL
1 vote377 views1 answer
Postgres convert text to number
SQL
0 vote192 views1 answer
Oracle session statistics
SQL