Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - 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

Object Extractor

Object Extractor Overview

Object Extractor > Object Extractor Overview

The Object Extractor allows the retrieval of the DDL text for creating the database objects. You can also retrieve the DDL for the object dependencies ordered by the lowest dependencies first.


Related Topics

Object Extractor Window

Object Extractor > Object Extractor Window

The Object Extractor window has the following panes and buttons:

Select objects to be extracted [left pane]

Displays a tree view of all database objects available for extraction.

Objects to extract [right pane]

Displays the list of selected objects to be extracted, duplicate objects cannot be added. A checkbox is available to include extraction of the object’s dependents.

DDL [bottom pane]

Displays the DDL script when Extract DDL is selected.


Button Function

Extract DDL

Extract the DDL of the selected object(s) to the bottom pane.

Extract to file

Extract the DDL of the selected object(s) directly to a file.


Abort the extraction process.


Related Topics

Extract Object DDL and Dependencies

Object Extractor > 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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating