The Table Window allows you to edit, add, delete and sort the data in a table. The Table Window also provides edit controls for editing blob data.

Filter Records

Please visit Filter Wizard for details.

Limit records

• Click Previous page button to view the previous set of records.
  
• Click Next page button to view the next set of records.
• To edit the number of records per page, click Preferences in the Navicat Menu. Edit the Number of row per page.

Sort records

You can sort your records on any combination of fields in Navicat's Table Window.

Click the field header to sort the record in ascending by this field. Click again the field header to sort the record in descending. Click one more time to remove the sorting

Blob Edit Control

The blob edit control allows you to easily edit your binary data. Loading a file to modify the contents of a blob field.

How to use blob control

• Click to activate the blob editor
• Double Click to select the blob field
• To insert or update data in the field, click to open the Open File dialog box and then choose a file.
• To get the data from the field, click to save the data into the file.
• To clear the data in the field, click .
• To undo your change made in blob control, click on the Cancel edit button at the bottom of the table
• If the input data is an image format, the image can display inside the control.
• Size of the stored data is shown at the top left corner of the control.