DDL
View DDL page
The DDL tab of the Preferences window allows you define the way the DDL is extracted for the database objects in the Database Explorer and the Object Extractor.
Place a DROP command before the object (Default = checked)
Specify whether to include the DROP command before the CREATE object command.
Qualify object with database and user name (Default = cleared)
Specify whether to place the database and user name in front of every object in the DDL.
Include indexes for table (Default = checked)
Specify whether to include the CREATE INDEX command when the DDL for a table is extracted.
Note: The settings for this tab are also changed from the Extraction Criteria window that can be optionally displayed at the beginning of the extraction process in the Object Extractor.