Python SQLITE3 - Referential Integrity-Delete records with CASCADE, RESTRICT, SET NULL/DEFAULT-Part7

preview_player
Показать описание
Python - How to use Sqlite3 database (Referential Integrity - How to delete records from parent table with CASCADE, RESTRICT, SET NULL, SET DEFAULT, NO ACTION) -Part7
This part covers -
1. Delete records from parent table
2. Default behavior explanation for Parent Child table with ON DELETE RESTRICT ON UPDATE RESTRICT,
3. Manual intervention required to delete records from parent table in case child tables are having dependent records,
4. How to control deletion of records from parent table with options like
- CASCADE,
- SET NULL,
- SET DEFAULT,
- NO ACTION
- RESTRICT

Рекомендации по теме