/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 vote208 views3 answers
Connect to mysql c# connection string C#
SQL
1 vote192 views1 answer
Where date = max(date) in sql
SQL
0 vote240 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
1 vote215 views2 answers
Oracle leftmost characters
SQL
2 votes264 views3 answers
3 days back in sql server
SQL
2 votes192 views1 answer
Wait delay in sql server
SQL
1 vote192 views1 answer
Partition by sql server
SQL
2 votes180 views1 answer
Oracle run_duration average
SQL
1 vote204 views1 answer
Sql count value greater than
SQL
1 vote182 views1 answer
Mysqli connect
SQL

Share