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

Set Row Height

Control-click anywhere on the table grid and select Set Row Height. Specify row height in the Set Row Height Dialog. The default value is 17.

Hint: This action applies on the current table grid only.

Set Column Width

Click right border at top of column and drag either left or right.
or
Control-click the column you want to set the column width with and select Set Column Width. Specify width in the Set Column Width Dialog. The default value is 100.

Hint: The result only applies on the selected column. To apply on all column, control-click the grid and select Set All Column Width.

Show/Hide Columns

If there are many columns in the table and you want to hide some of them from the table grid. Just simply control-click anywhere on the table grid and select Show/Hide Columns. Select the columns that you would like to hide.

The hidden column(s) will disappear from the table grid.

To unhide the columns, just simply control-click anywhere on the table grid and select Show/Hide Columns. Select the columns that you would like to redisplay.

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.