/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 vote365 views1 answer
Mysql previous year
SQL
25 votes393 views1 answer
How to update an attribute in MySQL
SQL
1 vote364 views1 answer
Liquibase alter column type / length
SQL
0 vote373 views1 answer
Date 3 months from today sql
SQL
0 vote364 views1 answer
C# mysql data reader from two tables
SQL
3 votes335 views1 answer
Dbms_scheduler drop_job
SQL
0 vote341 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote343 views1 answer
Django mssql backend
SQL
10 votes378 views4 answers
Mysql if else
SQL
0 vote336 views1 answer
Hibernate xml property MySQL url, username and password
SQL

Share