Rows
You can add, edit, or delete rows in the data editor.
Manipulating rows
Add a row
Click the Add Row icon (
) on the toolbar. Alternatively, right-click the table and select Add Row from the context menu.Press ⌘ N.
Delete a row
Select a row or rows.
To select multiple rows, click numbers in the gutter. Also, you can press Ctrl and click the necessary rows.
Click the Delete Row icon (
) on the toolbar. Alternatively, press ⌃ Y or ⌦.
Remove all rows in a table
Right-click a table and navigate to .
Clone rows
You can clone a selected row. The copy of the row is added to the end of the table.
To clone a row, right-click the row and select Clone Row. Alternatively, select the row and press ⌃ D.
Set the number of rows in the data editor
Set a number of rows in the result set
By default, when you issue a query, the number of returned rows is limited to 500. This limitation is introduced to avoid an overload (for example, when your SELECT statement returns one million rows).
To change this limit, open settings settings ⌃ ⌥ S and navigate to . In the Limit page size to field, specify a new number. To disable the limitation, clear the Limit page size to checkbox.
Also, you can click the Change page size list in the editor, and select a predefined value.
Make all rows visible simultaneously
Open settings ⌃ ⌥ S and navigate to .
Clear the Limit page size to checkbox, and click OK.
Click the Refresh button
or press ⌃ F5 to refresh the table view.
Navigation between rows
This chapter describes how you can navigate between related rows of one or several tables. For example, you can use this functionality to navigate between tables by using primary or foreign keys.
Depending on the value of the Limit page size to parameter, the result set might be divided into several pages. For example, you set the Limit page size to parameter to 100, but your query returned 200 rows. You will have two pages of rows, with 100 rows on each page. To navigate between pages, use the following controls:
Navigate between subsets of rows
: Navigates to the first page of the result set.
: Navigates to the previous page of the result set. Alternatively, press ⌃ ⌥ ↑.
: Navigates to the next page of the result set. Alternatively, press ⌃ ⌥ ↓.
: Navigates to the last page of the result set.
Go to a specified row
To navigate to a row with a specified number, right-click the table and select ⌃ G. In the Go to Row dialog, specify the row number and click OK.
Navigate to an object DDL
Right-click an object in the data editor and navigate to . Alternatively, open the Go to Action dialog by pressing ⌃ ⇧ A and type
DDL.
Navigate between related rows
Right-click the column in the table and select Go To. In the Go To submenu, you can select to which type of related rows you want to navigate.
Referenced Rows: rows that are referenced by the current object.
Referencing Rows: rows that are referencing the current object.
All Related Rows: both referenced and referencing rows.
If the Choose Target popup appears, select a table and a row. The information is divided in the following categories:
Referenced Rows Only/Referencing Rows Only: shows all the rows that are referenced or referencing the selected object.
First Referenced Row/First Referencing Row: shows the first occurrence of the matched row. This option performs multiple queries to calculate an offset of the first value occurrence.
Also, you can watch the Navigate by foreign keys video at youtube.com for another example.
