Answers for "mysql alter table drops foreign key"

mysql modify foreign key

-- 2 Step process
ALTER TABLE tbl_name_1 DROP FOREIGN KEY fk_name;
ALTER TABLE tbl_name_1 ADD FOREIGN KEY fk_name(fk_col)
            REFERENCES tbl_name_2(pk_name) ON DELETE RESTRICT;


-- Use to find the name of the FOREIGN KEY 
SHOW CREATE TABLE tbl_name;

Posted by: Guest on July-20-2021

Code answers related to "mysql alter table drops foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql alter table drops foreign key"

Code answers related to "mysql alter table drops foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql alter table drops foreign key"

Code answers related to "mysql alter table drops foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us