/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 vote216 views3 answers
Drop multiple columns in sql
SQL
4 votes261 views1 answer
Rename stored procedure in sql server
SQL
12 votes207 views4 answers
SQL Where
SQL
4 votes232 views1 answer
For loop postgresql
SQL
12 votes230 views6 answers
Between in sql
SQL
9 votes255 views3 answers
Date format in sql
SQL
5 votes233 views2 answers
Oracle apex debug mode
SQL
4 votes231 views1 answer
Add constraint fk
SQL
-1 vote226 views1 answer
Io
SQL
5 votes242 views3 answers
Postgres show databases
SQL

Share