Add or Remove list objects

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:

  1. Click Add
  2. On the Edit list of objects dialog, select the object that you want to add by expanding the schemas in the Supported objects tree until the object you want to add appears.
  3. Click Add. The object will be appear in the list of Objects to process.
  4. If the schema that contains the object that you want to add does not appear in the list, select Select schemas to display.

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:

  1. Select the object that you want to remove from the Objects to process list.
  2. Click Remove

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:

Output options

SQL options

Format options

You can do these tasks in any order.

Once you are satisfied with these options, click Generate.