Tables

You can use the context menu of the target structure ("Create new" → "New database node") to create a node that represents the structure of a table in a database (and is connected to that table).

Just select a connected database (via the alias) and a database table.

Dialogue "New database node"

(1) Type: "Table" or "Stored Procedure".

(2) DB alias: The alias. Example: "hub".

(3) Table/Proc.: Name of the table or stored procedure. Example: "comm_log".

As a result, you will get a structure like the following.

images/download/attachments/150864830/712-version-1-modificationdate-1695795496657-api-v2.png

The table columns will then appear as fields with matching data type and matching length. The field attribute "SQL column name" is taken from the database.

Stored procedure

Similar to tables, you can also create a structure for stored procedures (see above).

HSQL

You also have the option to go the other direction. I.e. you can create a node with fields in the target structure and then automatically create a table in an integrated HSQL database.