 |
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.
|
 |
- Select the menu item Database > Generate SQL Scripts or the
Generate SQL Scripts button from the main tool bar
- Select the open connection to use for script generation
- Select the type of script to be generated - CREATE TABLE or DROP
TABLE
- Select the Next button to proceed to the next step
- Select the catalog or schema containing the tables to be
scripted
- Select the required tables from the 'Available Tables' list using
the arrow selection buttons
- Alter the order in which each individual CREATE or DROP will
appear within the script using the Move button
- Select the Next button to proceed to the next step
- Enter the path where the generated SQL script will be saved
- 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
- Select the Next button to begin the script generation process
- Monitor the output pane for any errors
- Select the 'View generated script' check-box to open and
display the generated script within the central pane
|