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
- Edit one or more cells in a result row.
- Select the row's edit action.
- Review the generated
UPDATEstatement in the editor. - Execute it only after confirming the values and
WHEREclause.
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.