SQLite Table Editor
The SQLite table editor is one of the tools contained in the RazorSQL database client
for SQLite. It allows users to edit database table data in a spreadsheet like format. Users
can easily add and remove rows, or edit individual cells. The find / replace tool allows users
to quickly find and/or replace text. The edit in new window option allows users to easily
edit multi-line text.
See the Screen Shot for a visual look:
The table editor will automatically generate the SQL insert, update, or delete statements corresponding to any edits made by the user. The editor can then either execute these statements or dislay them for viewing by the user.
The SQLite database table editor allows users to filter what data is displayed in the table editor by modifying the SQL query used to populate the editor. Users can also specify the maximum number of rows to display in the editor.
When viewing query results in the query results pane of RazorSQL, users can easily edit a particular data cell by double-clicking the cell. This will launch the SQLite database table editor and select the cell that was clicked in the query results.
For updates and deletes, the SQLite editor will automatically append the appropriate keys of the table being edited to the generated SQL update and delete statements to prevent the unwanted modification of data. If no keys are defined for the table, the editor will prompt the user to select an appropriate number of columns to guarantee only the correct data gets modified.
For more information on the table editor, see the following documentation:
Edit Table Tool
RazorSQL also offers many other SQLite tools such as a SQLite database browser, an SQL query builder, GUI tools for managing SQLite objects and structures, and much more. See the main SQLite Features Page for more information.
Below are screen shots of the Mac and Windows / Linux versions of the SQLite table editor.
Mac Screen Shot
Windows / Linux Screen Shot