SQLite Related Help

Top Previous Next

In this part of the Database Workbench help you will find all SQLite specific items. This includes screenshots, specialized editors and settings and the meaning of general settings for SQLite related tasks.

Database Workbench comes with a SQLite library version 3.44.0 included.

Quick links:

•	Registering a SQLite Library

•	Using the Enterprise Manager with SQLite

•	Using the Database Navigator with SQLite

Limitations

Standard SQLite limitations for accessing a database using multiple applications may apply if you also have other applications using the same database as Database Workbench.

•

When using Database Workbench Pro edition or Enterprise edition without a SQLite module license, you can open SQLite databases but meta data object editors or reports are not available. If you do have a license and you open a database without registering it, the editors are available, but you have to select the database file each time you want to open the database.

•	SQLite does not support adding constraints to an existing table. If you do this using the editors in Database Workbench, it will generate a script that recreates the table and moves the data from the old table to the new and then renames the new table to have the original name.

•	When extracting meta data statements, all constraints are always included in the CREATE TABLE statement. You cannot select a constraint separately and extract the statement for it.

Opening a SQLite database without registering

To open a SQLite database without registering it, go to Tools | Open SQLite Database or click the toolbar button. Select a file and open it. This will used the SQLite version that comes with Database Workbench, without any extensions.