How do you generate the create scripts for multiple indexes (objects) of a schema?
RESOLUTION 1:
1. In Schema Browser, to the object tab you wish to create scripts for. Example: Index tab.
2. Select 1 or more indexes (using ctrl to highlight multiple if necessary).
3. Right click and select "Create Script". This will create the script on the clipboard where you can paste into text pad or directly to the Editor.
RESOLUTION 2:
Various object scripts can be created at one time using the Generate Schema Script tool. This is only available to installs with the DBA Module (enabled by the authorization key).
1. Go to Database | Export | Generate Schema Script. This is for the 9.0 install. If you have 8.6. and older it may be under the DBA menu.
2. Check of the settings in each of the tabs as necessary.
3. Specifically to choose the kinds of objects to create scripts for, select what kinds of objects from the Object Types tab.
4. Specify exactly which object to create scripts for you will need to go under Object Set tab, check off the "Specify Object Set" option, and use the blue plus sign to Load Objects of Selected Types (based on your choices form the Object Types tab).
5. From there load the list of objects and check off the specific objects to create scripts for.
RESOLUTION 3:
Select Database | Export | Export DDL menu option. This feature will allow to create DDL scripts for multiple objects from multiple schemas.
