Importing Structure via Database Nodes


images/download/thumbnails/44946788/arrow_up-version-1-modificationdate-1583803393119-api-v2.png Introduction: You can find a description of this phase in section Phase 4 (Introduction).


Tables


You can use the context menu of the target structure (Create newNew 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.


images/download/attachments/44946788/728-version-1-modificationdate-1650362690854-api-v2.png


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


images/download/attachments/44946788/712-version-1-modificationdate-1650344552930-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 Lobster_data HSQL database.