/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 vote349 views1 answer
Sql values not in another table
SQL
0 vote324 views2 answers
Mysql disable foreign key checks
SQL
1 vote338 views1 answer
Postgres concat_ws
SQL
5 votes336 views1 answer
Oracle scan source ddl
SQL
0 vote325 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote366 views1 answer
Logtash mysql cofiguration file
SQL
16 votes335 views3 answers
Order by sql query
SQL
2 votes342 views1 answer
Date conversion in mysql column
SQL
0 vote365 views1 answer
Like sql for second letter of the family name
SQL
0 vote356 views1 answer
Delete duplicate rows
SQL

Share