Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Extract Object DDL and Dependencies

To open the Object Extractor window

Click image\B_ObjectExtractor.gif.

From the left pane [Select objects to be extracted], select the objects to extract. You can select the user name (all objects belonging to the selected user), object type (all objects of the selected type belonging to the selected object) and a specific object name.

To select the objects for retrieving the DDL, use one of the following

  • Select the tree node from the left pane and click Add.

  • Click Browse and use the Add Database Objects window to select the database objects.

  • Double-click the database object or tree node.

  • Drag and drop the object over to the right pane [Objects to extract].

By default, all selected objects are extracted with dependents. Deselect the corresponding checkbox if you do not want to include dependents in the [Objects to extract] pane.

To display the DDL script on the bottom pane

Click Extract DDL.

To save the DDL script directly to file

Click Extract to file.

Before the object DDL is extracted, the Extraction Criteria window displays. This window allows you to select how the object DDL displays. If you disable this window, the DDL script is generated according to the selected parameters on the DDL tab in the Preferences window.

To abort the extraction of the DDL

Click Abort.

 

Related Topics

Extraction Criteria

The Extraction Criteria window provides options on how the object DDL displays. These options include:

Place a DROP command before the object

Specify whether to include the DROP command before the CREATE object command.

Qualify object with database and user name

Specify whether to place the database and user name in front of every object in the DDL.

Include indexes for table

Specify whether to include the CREATE INDEX command when the DDL for a table is extracted.

Place comments in script

Specify whether to place a comment before and after the DDL script for each object. The comment includes information on the database, user, object name and date and time of generation.

Show on next extraction

Specify whether to show the Extraction Criteria window next time DDL is extracted. If this window is not shown then the extraction option will be according to last selection.

 

Related Topics

Object Extractor Functions

Below is a list of available functions within the Object Extractor window.

Button or Menu

Function

 

Extract DDL

 

Extract to File

 

Abort

Edit Menu

image\B_SendToSQLOptimizer.gif

Send to SQL Optimizer

Edit Menu

image\B_CopytoIndexAdvisor.gif

Send to Index Advisor

Edit Menu

image\B_CopyToSQLWorksheet.gif

Copy to SQL Worksheet

 

Related Topics

SQL Repository

Related Documents