Help / Editors / Data model editor
  • Overview
  • How to?
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...). This script generates the integrity constraints, the indexes, ...
This script can be modified and run to create tables on a server.
How to?
To generate the SQL script corresponding to an analysis (or to a file):
  1. On the "Analysis" tab, in the "Analysis" group, expand "Generation" and select "Generate SQL script". The wizard starts.
  2. Select the tables/files for which the SQL script must be generated.
  3. Select the type of database for which the SQL script must be generated. All the available databases are listed.
  4. Specify the options for generating the SQL code:
    • Generate DROP TABLE (code for deleting the existing tables).
    • Generate the indexes.
    • Generate the integrity constraints.
  5. The generated script is displayed. This script can be saved in a specific file in order to be modified, then run.
Minimum version required
  • Version 11
This page is also available for…
Click [Add] to post a comment

Last update: 10/27/2022

Send a report | Local help