/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

0 vote222 views1 answer
Authentication modes in sql server
SQL
0 vote203 views1 answer
Convert .mdf to .bak
SQL
6 votes207 views6 answers
Count mysql
SQL
0 vote201 views1 answer
Sql last 7 days
SQL
0 vote216 views1 answer
Sql server convert to guid
SQL
5 votes195 views3 answers
Truncate function in sql oracle
SQL
2 votes200 views1 answer
Import large .sql files into lampp
SQL
-1 vote199 views2 answers
How to select the lowest values from table per client sql
SQL
5 votes202 views1 answer
AND OR NOT operators sql
SQL
0 vote198 views1 answer
Select top 3 sql
SQL

Share