/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 vote111 views1 answer
Sqlserver create table from select
SQL
0 vote113 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote122 views3 answers
Classement rang mysql 7
SQL
3 votes103 views2 answers
Funktion LOWER/UPPER sql
SQL
2 votes120 views1 answer
Oracle percentage
SQL
-1 vote99 views2 answers
Get day in sql
SQL
3 votes103 views2 answers
Df to sql pandas sql achemy
SQL
10 votes119 views6 answers
Sql between
SQL
1 vote101 views1 answer
Sql not equal multiple columns
SQL
0 vote115 views1 answer
Print hello world in plsql
SQL

Share