diff options
| author | lonkaars <loek@pipeframe.xyz> | 2022-10-04 15:42:54 +0200 |
|---|---|---|
| committer | lonkaars <loek@pipeframe.xyz> | 2022-10-04 15:42:54 +0200 |
| commit | 045cd3cd1dccb0a87db5cca390db895b7a4876f4 (patch) | |
| tree | a2914097219295c896301e95918fdcacc64f4c11 /opdracht-1/q6.sql | |
| parent | d1dca9e78af83bdd5e25086c1cddad754fb1dde5 (diff) | |
opdracht 1 klaar
Diffstat (limited to 'opdracht-1/q6.sql')
| -rw-r--r-- | opdracht-1/q6.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/opdracht-1/q6.sql b/opdracht-1/q6.sql index e8d43ff..9125755 100644 --- a/opdracht-1/q6.sql +++ b/opdracht-1/q6.sql @@ -1,2 +1,2 @@ -alter table `Order` drop foreign key KlantID; -alter table `Order` add constraint KlantID foreign key (KlantID) references Klant(ID) on update cascade; +alter table `Order` drop foreign key Order_ibfk_1; +alter table `Order` add constraint Order_ibfk_1 foreign key (KlantID) references Klant(ID) on update cascade; |