/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

1 vote267 views1 answer
Increase existing date in sql oracle
SQL
1 vote273 views1 answer
ORA-01950
SQL
0 vote311 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote290 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote213 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote277 views1 answer
Ajax error exception handeling
SQL
27 votes270 views6 answers
Set password mysql
SQL
0 vote247 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote263 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote268 views2 answers
Soql last year
SQL

Share