SQL Optimizer for SAP ASE 3.9 - Installation Guide

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 Overview

Object Extractor Window

Extract Object DDL and Dependencies

Object Extractor Functions