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
|
The SQL Repository stores the SQL statements that are used in the analysis of database performance. These may be SQL statements that you have identified as critical to the performance of your database application.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center