GUI

DL

sudo apt install sqlitebrowser

Foreignkeyが消せない

直接削除する方法はなさそう。。

https://www.techonthenet.com/sqlite/tables/alter_table.php

PRAGMA foreign_keys=off;

BEGIN TRANSACTION;

ALTER TABLE employees RENAME TO _employees_old;

CREATE TABLE employees
( employee_id INTEGER PRIMARY KEY AUTOINCREMENT,
  last_name VARCHAR NOT NULL,
  first_name VARCHAR,
  hire_date DATE
);

INSERT INTO employees (employee_id, last_name, first_name, hire_date)
  SELECT employee_id, last_name, first_name, hire_date
  FROM _employees_old;

COMMIT;

PRAGMA foreign_keys=on;

※DB Brower for SQLiteでExecute SQLする場合は、Begin Transactionは不要