From the object context menu in the left pane, click Open to see the Data pane.

To edit an entry, double-click a cell. You can also click View Value and enter the value. When you make an edit, the border of the gutter cell in that row changes to blue.

The icons available in the Data pane are:

• Create Row: Insert a new row into the database table. When you insert a row using the Create Row icon, the row is committed into the database.

• Delete Selected: Mark the selected row for deletion. When you mark a row for deletion, the border of the row changes to red.

• Commit: Commit all changes made to the database.

• Undo All: Revert all changes that are marked for commit.

Use the Filter icon at the top right corner to filter the column data. You can also right-click a cell to access the context menu to count rows, view a single record, export or copy the cell text to clipboard.

To view a Binary Large Object data type (BLOB), click the pencil icon for a BLOB data type. In the View Value dialog:

• The Image tab displays the loaded image, if the loaded BLOB type is an image.

• The Text tab displays the text file, if the loaded BLOB type is text.

• The Information tab displays details and enables you to perform the following actions:

  • Download: To download the image or text file of BLOB data type.

  • Load: To insert an image or text of BLOB data type.

  • Set NULL: To delete the object and set the value as NULL.