Answers for "alter table modify constraint mysql"

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

alter table mysql

ALTER TABLE contacts
  ADD last_name varchar(40) NOT NULL
    AFTER contact_id,
  ADD first_name varchar(35) NULL
    AFTER last_name;

Posted by: Guest on April-14-2020

Code answers related to "alter table modify constraint mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table modify constraint mysql"

Code answers related to "alter table modify constraint mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table modify constraint mysql"

Code answers related to "alter table modify constraint mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us