The syntax to drop a foreign key in SQLite is: PRAGMA foreign_keys=off; BEGIN TRANSACTION; ALTER TABLE table1 RENAME TO _table1_old; CREATE TABLE table1 ( column1 datatype [ NULL | NOT NULL ], column2 datatype [ NULL | NOT NULL ], ... ); INSERT INTO table1 SELECT * FROM _table1_old; COMMIT; PRAGMA foreign_keys=on; I couldn't find a way of defining foreign key constraints using the "Database Structure" tab. Syntax. I'd strongly recommend defining table definitions and constraints using a script rather than building them using the graphical editor - it makes it much easier to create new databases and to track changes to the schema.