You can also display a table or a query result set in text format. Supports syntax highlighting, SQL history, saving and loading scripts to/from files.Īlso supports interrupting the execution of long running queries. The result set is also editable if all columns in the selection query are from one table. SQLite Expert allows users to easily execute SQL scripts and display the results in the grid or as text. You can use Up, Down, PageUp and PageDown keys to traverse the grid cells. Clicking on the "Post" button in the navigator panel will save the data to database. You can just click a grid cell and modify its value. SQLite Expert allows users to insert, delete and edit the table data in the grid. You can click on these thumbnails to see a larger version. Here are some screenshots of SQLite Expert performing different actions on the demo database. Limit the number of records in result set Visual criteria constructing tool for Where and Having clauses Visual building of sub-queries and unions
User-friendly interface with drag & drop support View, add, delete, modify, reorder fieldsĬompletely visual building of complex SQL queries Restructure tables without losing existing data Import and export from and to text files (CSV, TSV) Register frequently used databases for using in SQLite Expert Execute SQL queries and display results in the grid or as text.Ĭompare editions of SQLite Expert to determine the one that best meets your needs.BLOB fields can be edited with the integrated hex editor. Currently supports BMP, JPG and PNG image formats. Display and edit data in the grid, including BLOB and image fields.Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.Build SQL scripts and generate views visually using the integrated Query Builder.Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables. Edit tables and views visually, without writing a line of SQL.SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.īy using SQLite Expert you will be able to:
SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating.
0 kommentar(er)
