To open the Object Extractor window
Click .
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.
The Extraction Criteria window provides options on how the object DDL displays. These options include:
Specify whether to include the DROP command before the CREATE object command.
Specify whether to place the database and user name in front of every object in the DDL.
Specify whether to include the CREATE INDEX command when the DDL for a table is extracted.
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.
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.
Below is a list of available functions within the Object Extractor window.
Button or Menu |
Function |
|
|
|
|
|
|
Edit Menu
|
|
Edit Menu
|
|
Edit Menu
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center