Edit a row#

You can change a table's contents directly in the Data view, without writing SQL. Database Client commits every edit to the database as you make it, and records it in the SQL log.

Change a cell value#

Right-click a cell and select Edit Cell to open the cell editor beside the grid. The editor is a full text panel, which suits long or structured values. It can read the value as JSON, XML, Plain text, SQL, or JavaScript. For JSON and XML, a Format button re-indents the content. Select Apply to write the value back.

To clear a value instead of setting one, select Set NULL from the same menu. If you drag a selection across several cells, the menu offers to set all of them to NULL at once.

Add and remove rows#

Right-click a row number, on the left edge of the grid, to insert a row above or below it, or to delete it. To delete several rows, select them with the row checkboxes or by dragging across them. Then select the delete option, which names how many rows it removes.

Deletes act on the real table straight away, so treat them as you would a DELETE statement.

Why a cell can be read-only#

A cell is only editable when Database Client can tell which row and column it belongs to. In a plain table that is always the case. In the results of a SQL query it is not. A computed column, or a value that could come from more than one place in a join, opens read-only in the cell editor with a short note that explains why. See running SQL for editing query results.