To navigate back and forth between the initial and referencing tables, use the history navigation buttons ( ) in the top toolbar of the editor. The referencing table opens in the same editor. To open a referencing table, press Ctrl+1 or right-click the cell and click Navigate->Referencing tables->: You can navigate with foreign keys or reference tables – those that reference the current table. Navigate Foreign Keys / Referencing Tables Hovering over these buttons displays the names of the tables or filtered views saved in the history. Use the forward and backward buttons in the top toolbar:.You can navigate among such tables and filtered views: HistoryĭBeaver remembers the history of actions such as applying filters to data, opening reference tables and other tables via links. Then in the Go to Row dialog box, enter the row number and click OK. To jump to a specific line, right-click anywhere in the table and click Navigate -> Go to Line on the context menu. To jump to the first or last row or move one row forward or backward, use the navigation buttons in the bottom toolbar or on the context menu: You can navigate through the result set using standard shortcuts Home, End, PgUp, PgDown, Ctrl+Home, Ctrl+End. If it is huge, it might cause program hangup or out-of-memory errors. NOTE: Be careful when fetching the whole result set. To fetch the whole result set, click the Fetch all rows button ( ) in the bottom toolbar or right-click the table and click Navigate -> Fetch All Data on the context menu. To see the details, click the details button in the status field. The number of rows fetched is visible in the status field under the data table: To do so, click the Fetch next page of results button ( ) in the bottom toolbar or right-click the table and click Navigate -> Fetch next page on the context menu. You can also manually fetch the next portion of data equal to the maximum result set size. You can disable this behavior in preferences. Once you scroll to the last row of the current result portion, DBeaver fetches the next portion (next N rows). The maximum number of rows that DBeaver fetches to display in the Data tab is specified in the Maximum result-set size field in the main toolbar: ` Alternatively, you can right-click a cell in the table and then click Navigate -> Row Count on the context menu.īy default, DBeaver limits the number of rows fetched to 200 (you can change this value in the main toolbar or in preferences). The number of rows appears in a status field next to the button. To learn how many rows the data table contains, click the Calculate total row count button in the bottom toolbar. If the result set has many rows, you can scroll the results page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |