ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Data model editor
  • Overview
  • How to?
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
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…
Comments
Click [Add] to post a comment

Last update: 10/27/2022

Send a report | Local help