/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

3 votes121 views1 answer
What is having clause
SQL
1 vote129 views1 answer
Pl sql ptint
SQL
10 votes135 views4 answers
Mysql one week ago
SQL
0 vote136 views2 answers
Sql searching via key word
SQL
0 vote134 views1 answer
Mysql update from n to 100
SQL
3 votes125 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
1 vote131 views1 answer
Sql select where id not exists in another table
SQL
0 vote137 views1 answer
Create table split string function in sql server
SQL
15 votes126 views5 answers
If null mysql
SQL
-1 vote146 views1 answer
How to Activate the database
SQL

Share