diff options
| -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", |
