Working in DB Table Editors

In the database model you use the table editor for editing, e.g. the columns of a database table.

What is Edited

In the table editor you edit the contents of an element, e.g. the columns of a database table.

For each type of Content Elements there is a tab in which the elements of this type are shown as rows in a table.

The table columns correspond to the Content Elements properties. The order corresponds to that in the Properties area in the Properties tool window and cannot be modified.

Right-clicking on the column head opens a drop-down list where you can select the displayed properties.

A table editor can be opened for the following elements of the database model:

Database table with tables for table columns, keys, foreign keys, indexes, triggers
Unique key with tables for 'Feature in the unique key'
Foreign key with tables for 'Feature in the relationship key'
Index with tables for 'Indexed table column'
Database view with tables for columns, "From" clauses, triggers, "Subselect From" clauses and subselects for combined views

Special Features

Special features in the table editor for elements of the database model:

In order to exist, a 'Feature in the unique key' requires a column in the table which is not yet in the key.

During creation, a dialog is opened in which one or more columns can be selected to be added to the key.
A 'Feature in the relationship key' can only be created if there are fewer columns in the foreign key than in the unique key referenced.

In this instance, a dialog opens on creation in which you can select the referenced column. At the same time, a new column is then created in the database table for the foreign key.

If you want to use an existing column in the foreign key, you can only assign this in the diagram editor by adding it to the foreign key using drag-and-drop.
In order to exist, an 'Indexed table column' requires a column of the table that is not yet in the index.

During creation, a dialog is opened in which one or more columns can be selected to be added to the index.
In order to exist, an 'option' requires there to be an option configured for the element type in the type system. During creation, a dialog is opened in which one or more options can be selected to be added to the element.

Maintaining Database Views

You can use the Complete View... context menu command for the easy maintenance of database views. The command is also available in the diagrams.

With this command, all columns that are not yet used in the database view although there is an appropriate "From" clause are offered for selection. When you confirm your selection, a linked view column is inserted into the database view for each selected column.

Searching in the Table

Prerequisites

The table editor contains entries.

Context

You want to find certain entries in the table.

How to proceed

Select Design>Find>Find in Table (Ctrl+Shift+F).

An input field for searching for the string, an arrow icon () for navigating through the search results and an icon for closing the search area appear above the columns. The and icons show you that there are no further search results above or below, respectively.
Enter the string you are looking for in the <Search> input field.

All table cells which contain the string are highlighted and can be navigated through using the and icons.