/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 vote139 views1 answer
How to start my sql server on mac
SQL
0 vote145 views1 answer
Firebird where
SQL
1 vote157 views1 answer
Sqlite create index
SQL
1 vote105 views1 answer
Import in mysql without a software
SQL
0 vote144 views1 answer
Multiple tricky query in sql server
SQL
1 vote138 views1 answer
Mysql get domain from url
SQL
0 vote143 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote137 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote157 views1 answer
On delete set default
SQL
2 votes146 views1 answer
Metasploit start postgresql
SQL

Share