Choosing the Output options
To choose a destination for the generated SQL, you must be on the Generate SQL dialog.
This task is covered in Generate SQL for database objects.
You can choose to open the generated SQL in Run SQL Scripts or you can write
the output to a either a Database source file or to a PC file.
To display the generated SQL in Run SQL Scripts:
- Select the Output tab on the Generate SQL dialog.
- Select Open in Run SQL Scripts.
To write the generated SQL to a Database source file:
- Select the Output tab on the Generate SQL dialog.
- Select Write to file.
- Select Database source file as the file type.
- Specify the schema that contains the database source file to write the generated SQL to in the
Schema field.
- Specify the file name of the database source file that you want to write the generated SQL to in the
File name field.
- Specify the member name in the Member field.
- Select Append to add the generated SQL to the end of the file. This is the default.
To write the generated SQL to a PC file:
- Select the Output tab on the Generate SQL dialog.
- Select Write to file.
- Select PC file as the file type.
- Specify the file location in the Location field. You can browse for this
location by selecting Browse.
You have now chosen the destination for the generated SQL.
Next, you can change the default values for:
SQL options
Format options
You can do these tasks in any order. Additionally, you can:
Add or remove list objects
Once you are satisfied with these options, click Generate.