DataSpell
 
2023.2
Shortcuts: Windows
Get DataSpell
You are viewing the documentation for an earlier version of DataSpell.
  1. Database Tools and SQL
  2. Data editor and viewer
  3. Rows

Rows

Last modified: 20 September 2023

In the data editor, you can add, clone, delete, and navigate between related rows.

rows in the data editor

Manipulating rows

Add a row

  1. Click the Add Row icon (The Add New Row icon) on the toolbar. Alternatively, right-click the table and select Add Row from the context menu.

  2. Press AltInsert.

tip

Note that the context menu Clone Row command Ctrl0D can be used as an alternative.

Delete a row

  1. Select a row or rows.

    To select multiple rows, click numbers in the gutter. Also, you can press Ctrl and click the necessary rows.

  2. Click the Delete Row icon (the Delete Row icon) on the toolbar. Alternatively, press Ctrl0Y or Delete.

Remove all rows in a table

  • Right-click a table and navigate to SQL Scripts | Truncate….

    Remove all rows in a table

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 Ctrl0D.

    Clone a row

Edit multiple rows

This chapter describes how you can edit multiple selected rows at once.

Paste CSV lines

In DataSpell, you can directly paste multiple CSV lines into a table. The original lines will be split into columns in accordance with the commas. The content of CSV lines will replace that of table rows. If the table does not contain enough rows, new ones will be created.

  1. Select the rows that you want to paste your CSV lines into.

    Alternatively, select the table row that you want to paste the first line of your CSV lines into.

  2. Press Ctrl0V. Alternatively, select Paste in the context menu.

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 CtrlAlt0S and navigate to Tools | Database | Data Editor and Viewer. In the Limitations | 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

  1. Open settings CtrlAlt0S and navigate to Plugins | Database | Data Views.

  2. Clear the Limit page size to checkbox, and click OK.

  3. Click the Refresh button the Refresh button or press CtrlF5 to refresh the table view.

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:

  • The first page icon: Navigates to the first page of the result set.

  • The previous page icon: Navigates to the previous page of the result set. Alternatively, press CtrlAlt0↑.

  • The next page icon: Navigates to the next page of the result set. Alternatively, press CtrlAlt0↓.

  • Go to the last page icon: 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 Go To | Row… Ctrl0G. In the Go to Row dialog, specify the row number and click OK.

    Go to a specified row

  • In the data editor, right-click a cell of the column whose DDL you want to open, and navigate to Go To | DDL.

    Alternatively, open the Go to Action dialog by pressing CtrlShift0A and type DDL.

  • Right-click a column in a 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.

    Referenced and referencing data

    In the data editor, you can now select several values and navigate to the related data.

    tip

    Also, you can watch the Navigate by foreign keys video at youtube.com for another example.