![]() Next, let's add some data to these tables: INSERT INTO table1 SELECT * FROM _table1_old įirst, let's start by creating our 2 tables ( departments and employees): The syntax to add a foreign key with cascade delete to an existing table in SQLite is: PRAGMA foreign_keys=off ĪLTER TABLE table1 RENAME TO _table1_old 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |