Hacker News new | ask | show | jobs
by wvenable 5101 days ago
Does that actually work for dropping and renaming tables? I thought I tried that.
2 comments
rogerbinns 5101 days ago
In any event you can get the foreign keys from sqlite_master, delete them during the reorganisation and then put them back afterwards.
link
premchai21 5101 days ago
It does in 3.7.13 (and presumably older versions, but I don't have a solid record of this immediately available).
link