How to make forbidden changes to SQLite tables
2 days ago
- Some SQLite table changes require more than a simple ALTER TABLE command, such as adding ON DELETE CASCADE to a foreign key.
- A workaround is to create a new table with the correct structure, copy data from the old table, rename the old table, rename the new table, and then drop the old table if everything is fine.
- The process is demonstrated with SQL commands: CREATE TABLE, INSERT INTO, ALTER TABLE RENAME, and DROP TABLE.
- This method avoids hacky solutions and ensures data integrity.