Supports password protected databases (requires third party SQLite library – not included).Copy tables between databases using drag and drop.Customize the look and feel of the application using skins.Copy/Paste tables between databases via clipboard.Copy/Paste records between tables via clipboard.Advanced data editing capabilities in the grid: image, BLOB and text editors.
Advanced SQL editor with code completion and syntax highlighting.Supports virtual tables including RTREE, FTS3 and FTS4.Manage views: create, delete, rename, restructure.Restructure tables: fields, indexes, foreign keys, unique and check constraints, triggers.Manage tables: create, delete, rename, reindex.Supports attached databases and SQLite extensions.Check integrity, reindex all tables, transaction support.Manage SQLite3 databases: create database, view/change parameters.In addition, it can easily establish complex SQL queries, supports import and export database, supports encrypted database, and so on.īTW, when the function of the freeware SQLiteSpy and SQLiteStudio can’t meet your needs, do remember to give SQLite Expert a try. This includes a visual query builder, a SQL editor with syntax highlighting function, code auto-complete, powerful table and view designer, import and export function, etc. SQLite Expert supports all SQLite features designed for graphical interface. It is known as the best auxiliary software to develop SQLite3 database. SQLite Expert is currently the most excellent SQLite database visual manager, which allows user to create, edit, copy, extract, and perform other database operations on a SQLite server.
0 kommentar(er)
