How to use SQL Script Builder ?
To use SQL Script Builder, simply follow these steps : First be sure you have set a valid system source (DSN). There’s three ways generating SQL scripts, first one is : 1. Select the source in the treeview. 2. Click on the blue button on the toolbar. 3. Select table(s) then click the Done button. 4. Choose or not to add foreign key(s). 5. The script will be generated. You can save the script in a SQL file. Second way is : 1. Right click on the data source in the tree view, options menu will appear. 2. Click on generate SQL, the list of available tables will be listed. 3. Select table(s) then click the Done button. 4. Choose or not to add foreign key(s). 5. The script will be generated. You can save the script in a SQL file. Third way is : 1. Double click on the data source in the tree view, the tables will be listed. 2. Double click on the table, the script will be generated. 3. You can save the script in a SQL file. You can set additional features by selecting the type of SQL Script y
