PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • How to proceed?
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 proceed?
To generate the SQL script corresponding to an analysis (or to a file):
  1. Select "Structure of files .. Generate the SQL script". The wizard starts.On the "Analysis" pane, in the "Analysis" group, expand "Generation" and select "Generate the 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 required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment