Start Today

← Documentation

Edit Results and Generate DML

Edit Results and Generate DML

For SELECT results, double-click a non-primary-key cell to edit it. Short values are edited inline; longer values open in a dialog. Press Enter or click outside the cell to commit the local change.

Edits do not change the database until you generate and execute SQL.

Generate UPDATE

  1. Edit one or more cells in a result row.
  2. Select the row's edit action.
  3. Review the generated UPDATE statement in the editor.
  4. Execute it only after confirming the values and WHERE clause.

Generate DELETE

Run a SELECT, select the row delete action, review the generated DELETE statement, then execute it.

Both actions depend on primary keys being present in the result. Test destructive statements on non-production data first.

Edit result cells locally and generate UPDATE or DELETE statements.

Read more