Database table editor

Database table editor displays data contained in database tables and views. Editor displays tables in a common way, as a number of fields (columns), and rows.

You also use the table editor to see the model execution logs, but they are shown in read-only mode, you can only view data, but not edit data.

 To open the database table editor

  1. In the Projects tree, expand the model's Database item.
  2. In the Database branch, double-click the table item. You will see the database table editor opened in the centre of the workspace. 

Editing table values

When you create empty database tables, you may need to enter the data in the table manually.

 To enter a new value

  1. Click the table cell, and type the new value there. 

 To modify cell(s)

  1. Select the cells you want to modify. Single mouse click selects one cell. To select multiple records, use Shift+click and Ctrl+click (Cmd+click on Mac OS), or select the cells with the mouse (drag with the left mouse button being pressed).
  2. Right-click the selection, and select the required action (Cut, Copy, Paste, Clear contents) from the context menu.

 To modify the complete row (record)

  1. In the leftmost column displaying the record numbers, select the rows you want to modify. Single mouse click selects one record. To select multiple records, use Shift+click and Ctrl+click (Cmd+click on Mac OS).
  2. Right-click the selection, and select the required action (Cut, Copy, Paste, Clear contents, Delete rows)  from the context menu.
Below we will give the detailed instructions for one specific command: deleting a set of table records.

 To delete table record(s)

  1. In the leftmost column displaying the record numbers, select the rows you want to delete. Single mouse click selects one record. To select multiple records, use Shift+click and Ctrl+click (Cmd+click on Mac OS).
  2. Right-click the selection, and select Delete rows from the popup menu. 

Column icons

- The column can contain only unique values.

- The column is indexed. 

- The column acts as a foreign key. Foreign key is a field in one table that uniquely identifies a row of another table by referring to the primary key defined there. For example, you have a table named FLIGHT that has a primary key named FLIGHT_ID. Another table called FLIGHT_DETAILS has a foreign key which references FLIGHT_ID to uniquely identify the relationship between both the tables.

 - The records in the table editor are currently sorted by values in this column, in ascending order.

 - The records are sorted by values in this column, in descending order.