To edit the list of objects in the Objects for which to Generate SQL list, you must be on the Generate SQL dialog. This task is explained in Generate SQL for database objects.
To add objects to the Objects for which to Generate SQL list:
Note: You can add a schema and all of the objects that it contains by selecting the schema and clicking Add. You can also add all objects of a certain type by selecting the type of objects and clicking Add. All objects of the selected type are added.
To remove objects from the Generate SQL list:
Once you have all of the objects that you want to generate SQL for in the Objects to process list, click OK.
Next, you can change the default values for:
You can do these tasks in any order.
Once you are satisfied with these options, click Generate.