The Table Data Editor toolbar contains navigation aids and action buttons that help you manage, find, and edit the data in a database table.
Table Navigation
Use the following features to navigate to specific rows in a large table.
| Option | Description |
|---|---|
| Row | Type the row number to display at the top of the table data grid. Use the drop-down menu to select a recent row number. |
| of | Shows the number of data rows in the table. You cannot edit this field. |
| Page Size | Select the number of rows to include per page from the drop-down list. For example, if you select 1000, the first page begins at 1, and the second page begins at 1001. The default page size is 500. |
Actions
Click toolbar icons to perform tasks.
| Option | Icon Label | Description |
|---|---|---|
 |
Select First Page | Goes to the first page of table data pages. |
 |
Select Previous Page | Displays next page. |
 |
Select Next Page | Displays previous page. |
 |
Select Last Page | Goes to last page of table data pages. |
 |
Save | Commits data changes to the database. You can view the SQL DDL statement in the SQL Preview view before you click the Save icon. |
 |
Filter by Edits | Displays the Show Edits dialog. |
 |
SQL Preview | Displays the SQL Preview dialog to view generated SQL. |
 |
Revert | Reverts values back to pre-edit states. |
 |
Data Filter/Sort | Displays the Data Filter dialog to specify filter and sort data rules. |
 |
Export All | Displays the Export Data Wizard which exports all data. |
 |
Refresh | Refreshes table data list from data in the database. |