We have also added a new constraint editor.
This should make editing the schema of large tables a lot faster. With this release DB4S keeps track of all your modifications, only applying them in one single process when clicking the OK button. Before each of these modifications would be carried out immediately which, for large tables, makes editing them very slow and tiresome. For example, when renaming a column you might want to edit its data type or default value too. Often you do not edit just one bit of your table schema. This gives you the full ALTER TABLE support we offer but additionally, all the benefits just mentioned. Starting with this release DB4S makes as much use of this new feature as possible.
Download sql tabs update#
This does not only make renaming columns a lot faster, it makes it safer too because the new process is less prone to errors and also makes sure to update all references to the renamed column in your indices and triggers. SQLite 3.25.0 added support for renaming columns with the ALTER TABLE command (previously you had to create a new table with the renamed column, copy all data over, delete the old table, then rename the new table - even leaving out some details of the process hereā¦).
SQLiteDatabaseBrowserPortable_3.12.0_ - PortableApp for Windows.DB.-3.12.0-win64.msi - Standard installer for 64-bit Windows.
DB.-3.12.0-win32.msi - Standard installer for 32-bit Windows.