Table data editor

You can use the table data editor in the workbench to modify the data in a database.

Make changes in the editor, then save your changes. When you save your changes, the appropriate commands (for example, UPDATE, INSERT, or DELETE) run on the database server. The Data Output View displays messages that indicate whether the actions ran successfully.

The table data editor retrieves and displays the maximum number of rows that are specified in the Data > Output page in the Preferences window.

The table data editor supports standard workbench editor actions, for example: