/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

1 vote325 views1 answer
Multiple count in sql
SQL
5 votes317 views2 answers
Sql server check port number
SQL
0 vote302 views1 answer
How to drop columns with constraint from a table in sql script
SQL
4 votes294 views2 answers
Select todays data postgres query
SQL
14 votes333 views6 answers
Auto_increment mysql
SQL
4 votes324 views1 answer
Add constraint fk
SQL
0 vote348 views1 answer
Mysql 3 months ago
SQL
0 vote310 views1 answer
Mariadb used space
SQL
0 vote332 views1 answer
C# add a textbox in mysql select
SQL
0 vote332 views1 answer
Search starting with mysql
SQL

Share