Only in DbVisualizer Pro
This feature is only available in the Pro edition. In the Free edition, please execute the corresponding SQL in the SQL Commander.
To edit table data:
- Expand nodes in the Databases tab tree under the connection node until you find the table,
Double-click on the table node to open its Object View tab,
Open the Data sub-tab
- Edit column values directly in the grid, add and remove rows by clicking on the buttons in the toolbar,
- Save the edited data by clicking on the Save button in the toolbar.
Note that if the table does not have any declared Primary Key, you will be prompted to select the column(s) that uniquely identify a row.
You can learn more about the editing features in Editing Table Data.