sqlite3.exe needs a restart when a table structure is updated

Viewed 77

After I've launched sqlite3.exe my_table, I update the DB schema (add/remove columns) from the outside (for ex. PHP laravel in my case), then I check the table structure with PRAGMA table_info(my_table): the schema isn't updated. If I close then relaunch sqlite3.exe I see the update.

Is it an expected behavior that sqlite3.exe needs to be restarted if the data structure has been changed from the outside ?

1 Answers

Yep. If data has been edited externally it needs to be reloaded into the program.

Related