AppCode 2020.3 Help

Rows

You can add, edit, or delete rows in the data editor.

rows in the data editor

Manipulating rows

Add a row

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

  2. Press ⌘N .

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 ⌃Y or .

Remove all rows in a table

  • Right-click a table and navigate to Database Tools | Truncate... .

    Remove all rows in a table

Clone a row

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

    Clone a row

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 Tools | Database | Data Views. 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

  1. Open settings ⌃⌥S 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 ⌃F5 to refresh the table view.

Go to a specified row

  • To navigate to a row with a specified number, right-click the table and select Go To | Row ⌃G . In the Go to Row dialog, specify the row number and click OK.

    Go to a specified row
Last modified: 31 December 2020