Generating Database Scripts


The Generate Scripts function allows for the creation of database CREATE TABLE or DROP TABLE scripts (reverse engineering a schema) within a selected database connection.
  1. Select the menu item Database > Generate SQL Scripts or the Generate SQL Scripts button from the main tool bar
  2. Select the open connection to use for script generation
  3. Select the type of script to be generated - CREATE TABLE or DROP TABLE
  4. Select the Next button to proceed to the next step
  5. Select the catalog or schema containing the tables to be scripted
  6. Select the required tables from the 'Available Tables' list using the arrow selection buttons
  7. Alter the order in which each individual CREATE or DROP will appear within the script using the Move button
  8. Select the Next button to proceed to the next step
  9. Enter the path where the generated SQL script will be saved
  10. Select whether to include any table constraints and if these should be generated as a part of each individual CREATE TABLE statement or as ALTER TABLE statements at the end of the script
  11. Select the Next button to begin the script generation process
  12. Monitor the output pane for any errors
  13. Select the 'View generated script' check-box to open and display the generated script within the central pane