/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 vote185 views1 answer
Oracle db get table sizes
SQL
0 vote183 views1 answer
Linux upload database to mysql
SQL
3 votes191 views2 answers
Sql get month name
SQL
0 vote195 views1 answer
Add sqlcmd to path linux
SQL
0 vote201 views1 answer
How to connect to xampp sql server on windows cmd
SQL
11 votes187 views4 answers
Query DISTINCT
SQL
0 vote194 views1 answer
Subquery aggregation
SQL
1 vote176 views1 answer
Show indices in mysql table
SQL
0 vote196 views1 answer
Frename oracle
SQL
15 votes186 views2 answers
Open postgress in terminal mac
SQL

Share