/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 vote157 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote141 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote130 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote119 views1 answer
Oracle list chain steps
SQL
2 votes141 views1 answer
Apex execute batch job
SQL
2 votes120 views1 answer
SQL IF ELSE
SQL
0 vote136 views1 answer
Power query datetime to date
SQL
0 vote120 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote126 views1 answer
Postgresql isnull with max
SQL
0 vote77 views1 answer
Copy table dbeaver
SQL

Share