Cells

Edit

F2

Edit a value in the selected cell or cells. Alternatively, you can double-click the cell and start typing a value. The Edit command is unavailable for read-only values.

• To open the auto-completion list, press Ctrl+Space.

• To confirm your changes, press Enter.

• To cancel editing, press Escape.

Open in Value Editor

Shift+Enter

Open in a separate value editor where you can edit data that is stored in the cell.

For more information about the editor, refer to Value editor.

Show Aggregate View

Open the aggregate view where you can select values of multiple cells and get a single summary value.

For more information about the view, refer to Aggregate view.

Revert Selected

Ctrl+Alt+Z

Revert changes that you made to a cell value. You can select a scope of different cells and revert values in this scope.

For more information about reverting changes, see Submit changes to a database.

Set Highlighting Language

Select a language that the IDE should use to highlight data in a cell.

Change Display Type

Select how the IDE should display binary data in the column. 16-byte data is displayed as UUID by default.

Set DEFAULTSet DEFAULT

Ctrl+Alt+D

Set the current cell value to the default value or the value that you specified for the column.

For more information about how to view or set a default value, see Manage default and NULL values for a cell.

Set NULLSet NULL

Ctrl+Alt+N

Set the current cell value to NULL.

For more information about how to allow a NULL value, see Manage default and NULL values for a cell.

Load File…

Load a file into the field.

Save LOB…

For the cells that contain a binary large object (LOB). Save content of a cell into a file.

Copy

Ctrl+C

Copy selection to the clipboard.

Copy Aggregation Result (SUM)

Copy a summary value for a range of cells. By default, AppCode copies the SUM aggregation result. To change the default, right-click the status bar and ensure that the Aggregator option is selected. Click the aggregator widget on the status bar and select the aggregator to use as default.

Paste

Ctrl+V

Paste the contents of clipboard into the table.

Add Row

Add a row to the end of a table.

Delete Row

Alt+Delete

Delete selected rows.

Clone Row

Create a duplicate of the selected row and adds the duplicate to the end of a table.

Quick Documentation

Ctrl+Q

Show information about selected objects. For different database objects, Quick Documentation shows corresponding information. For example, for a group of cells, you will see a summary for the selection. You can preview it in a regular or in a transposed view and also see the related records by their foreign keys.

Go To | Navigation Bar

Jump to a navigation bar.

Go To | Database

Open the selected object in the Database tool window.

Go To | Related Symbol

Navigate to one of the related objects.

Go To | DDL

Open an object definition (DDL).

Go To | Row…

Ctrl+G

Jump to a specified row.

In the Go to Row dialog, specify the column and row number (use the column:row pattern).

Go To | All Related Rows

F4

Jump to a related record.

The command options are a combination of those for Go To | Referenced Rows and Go To | Referencing Rows. Read more about related data in Navigate between related data.

The command is not available if there are no related records.

Go To | Referenced Rows

Ctrl+B

Switch to a record that the current record references. If more than one record is referenced, select the target record in the popup that appears.

Read more about related data in Navigate between related data.

The command is not available if there are no referenced records.

Go To | Referencing Rows

Alt+F7

Use this command or shortcut to see the records that reference the current record. Read more about related data in Navigate between related data. In the popup that appears there are two categories for the target records:

• First Referencing Row: all the rows in the corresponding table are shown, and the first of the rows that references the current row is selected.

• Referencing Rows Only: only the rows that reference the current row are shown.

The command is not available if there are no records that reference the current one.

Filter by

Select a filter that you want to a column.

Full-Text Search…

Ctrl+Alt+Shift+F

Open a search window where you can search for data in your database or a group of databases.

Gif

Export Table to Clipboard

Copy the whole table to the clipboard. This action does not depend on Limit page size to setting.

Switch Session (your_current_session_name)

Open a window to select another session or create a new one. For more information about sessions, see Manage connection sessions.