/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

15 votes300 views2 answers
How to know the username of postgresql
SQL
1 vote309 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote308 views1 answer
Sql waitfor
SQL
18 votes307 views3 answers
Mysql number format
SQL
0 vote397 views1 answer
Sqlite display headers on columns
SQL
0 vote351 views1 answer
Mysql order by rand limit 1 really slow
SQL
1 vote326 views2 answers
Sql for date greater than
SQL
0 vote341 views1 answer
Spark sql grows beyond 64 kb
SQL
1 vote354 views1 answer
Postgres left join
SQL
1 vote311 views1 answer
How to drop function in sql
SQL

Share