Importing Structure via Database Nodes

Tables

You can use the context menu of the destination structure to create a node that represents the structure of a table in a database (and is connected to that table).

images/download/attachments/21302669/Datenbankknoten_1_EN-version-1-modificationdate-1528795382000-api-v2.png

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

images/download/attachments/21302669/Datenbankknoten_2_EN-version-1-modificationdate-1528795382000-api-v2.png

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

images/download/attachments/21302669/Datenbankknoten_3_EN-version-1-modificationdate-1528795382000-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.

images/download/attachments/21302669/Datenbankknoten_2b_EN-version-1-modificationdate-1528795382000-api-v2.png

HSQL

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