/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 vote170 views1 answer
Call rest api from postgresql
SQL
0 vote165 views1 answer
Oracle list subpartitions
SQL
0 vote158 views1 answer
Oracle execute package dblink
SQL
8 votes301 views4 answers
Convert date to dd/mm/yyyy sql
SQL
5 votes172 views1 answer
AND OR NOT operators sql
SQL
0 vote233 views1 answer
Mysql get longest string in column
SQL
1 vote177 views1 answer
Join first name and last name sql
SQL
0 vote159 views1 answer
Check index sql server
SQL
1 vote173 views1 answer
Md5 encryption for existing records
SQL
36 votes185 views6 answers
Rename table sql
SQL

Share