/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 vote182 views1 answer
Dnsmasq.conf location macos
SQL
0 vote275 views1 answer
Ora 00001 error catch plsql
SQL
0 vote238 views5 answers
How to make trigger in phpmyadmin
SQL
2 votes154 views1 answer
Foreign key example in dbms
SQL
0 vote255 views1 answer
How to compile a function in oracle
SQL
0 vote210 views1 answer
Sql datediff month
SQL
0 vote204 views1 answer
How to use query in nosql
SQL
2 votes193 views1 answer
Plsql block
SQL
0 vote200 views1 answer
Call scalar valued function sql
SQL
1 vote208 views1 answer
Oracle difference between two dates in years
SQL

Share