Instead you will need to rename the table, create a new table with the foreign key, and then copy the data into the new table. You can not use the ALTER TABLE statement to add a foreign key with cascade delete in SQLite. How to Add a Foreign Key with Cascade Delete to an Existing Table Then we've created a foreign key called fk_departments on the employees table that references the departments table based on the department_id field.īecause of the cascade delete, when a record in the departments table is deleted, all records in the employees table will also be deleted that have the same department_id value. In this example, we've created a primary key on the departments table that consists of only one field - the department_id field. ( employee_id INTEGER PRIMARY KEY AUTOINCREMENT, ( department_id INTEGER PRIMARY KEY AUTOINCREMENT,

Let's look at an example of how to create a foreign key with cascade delete using the CREATE TABLE statement in SQLite.

REFERENCES parent_table (column1, column2. The syntax for creating a foreign key with cascade delete using a CREATE TABLE statement in SQLite is: CREATE TABLE table_nameįOREIGN KEY (column1, column2. How to Create a Foreign Key with Cascade Delete using a CREATE TABLE statement Syntax

Godot sqlite