/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

2 votes102 views1 answer
Sql select in list
SQL
0 vote140 views1 answer
How to get employee having maximum experience in mysql
SQL
1 vote207 views1 answer
Sql oracle update multiple rows
SQL
0 vote149 views1 answer
Mysql search multiple tables
SQL
0 vote242 views1 answer
ORA-00942
SQL
0 vote188 views1 answer
Alter column to not null with default value sql server
SQL
3 votes156 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
12 votes166 views1 answer
Psql drop column
SQL
12 votes166 views4 answers
How to check mysql version ubuntu
SQL
0 vote177 views3 answers
Join
SQL

Share