/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

5 votes196 views1 answer
Oracle nls instance
SQL
10 votes186 views1 answer
How to import database in mysql by cmd
SQL
7 votes176 views1 answer
Mysql iif
SQL
0 vote318 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote719 views1 answer
Sql show table name in result
SQL
0 vote204 views1 answer
Delete a temporary table mysql
SQL
1 vote178 views1 answer
Postgresql contains
SQL
0 vote174 views1 answer
Get the previous column of a table in mysql
SQL
4 votes173 views3 answers
Postgres set default value
SQL
0 vote242 views1 answer
Mysql could not fetch tables
SQL

Share