/SQL/Alter foreign key

Alter foreign key

Alter table add foreign key mysql

ALTER TABLE orders
ADD 
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

9

Add constraint fk

ALTER TABLE Orders
ADD CONSTRAINT FK_PersonOrder
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);

4

Alter foreign key

ALTER TABLE Employee
ADD FOREIGN KEY (DeptNo) REFERENCES Department(DeptNo);

1

Source: computerscienceai.com

Similar codes

2 votes235 views4 answers
List databases in sql server
SQL
0 vote241 views1 answer
UNION ALL LEFT JOIN
SQL
5 votes244 views2 answers
Mysql import gzip db
SQL
0 vote235 views1 answer
How to create a new shema using query languaage
SQL
0 vote252 views1 answer
Sql select sum group by id laravel join
SQL
3 votes233 views4 answers
Mysql decimal
SQL
3 votes240 views2 answers
Postgresql select all column names
SQL
0 vote245 views1 answer
Mysql wait_timeout
SQL
3 votes226 views1 answer
Sql timestamp to date
SQL
0 vote233 views1 answer
Postgres enumerated type
SQL

Share