diff options
| author | W. Kosior <koszko@koszko.org> | 2026-02-03 12:00:01 +0100 |
|---|---|---|
| committer | W. Kosior <koszko@koszko.org> | 2026-02-03 12:00:01 +0100 |
| commit | 1a592fec00df43cf90d358e10de31195a2a2f739 (patch) | |
| tree | 351bab3856ab7c74198cab8cedd6ad813ae6834b | |
| parent | fdc69a0703bfc720c0f3692e67175bd375729ecc (diff) | |
| download | AGH-db-lectures-magister.tar.gz AGH-db-lectures-magister.zip | |
| -rw-r--r-- | 07-data-definition-in-sql/data-definition-in-sql.ipynb | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/07-data-definition-in-sql/data-definition-in-sql.ipynb b/07-data-definition-in-sql/data-definition-in-sql.ipynb index 12a011e..2108cf3 100644 --- a/07-data-definition-in-sql/data-definition-in-sql.ipynb +++ b/07-data-definition-in-sql/data-definition-in-sql.ipynb @@ -566,7 +566,7 @@ "\n", "Analogously, for updates to the referenced table rows, we can specify `ON UPDATE SET DEFAULT`, etc.\n", "\n", - "Since the `PRIMARY KEY` constraint creates a dependence of one table on another, a DBMS shall, by default, prevent dropping of a table that is referenced by another one. This can be overriden with the `CASCADE` keyword. Therefore, `DROP TABLE invoices` shall fail, and `DROP TABLE invoices CASCADE` shall succeed, causing the `ids` table to be dropped as well.\n", + "Since the `FOREIGN KEY` constraint creates a dependence of one table on another, a DBMS shall, by default, prevent dropping of a table that is referenced by another one. This can be overriden with the `CASCADE` keyword. Therefore, `DROP TABLE invoices` shall fail, and `DROP TABLE invoices CASCADE` shall succeed, causing the `ids` table to be dropped as well.\n", "\n", "The `FOREIGN KEY` clause requires the referenced columns hold unique tuples. As long as we have either\n", "\n", |