SQL Scripts Options

Option name	Descriptions
Generate the DROP TABLE Statement	If checked, the DROP TABLE statement is generated before the CREATE TABLE statement
Omit Schema Names	Lets you specify whether to omit schema (owner) names in SQL scripts for DDL statements.
Convert cascade referential integrity constraint to no action	Converts Foreign Keys with CASCADE action to Foreign Keys with NO ACTION action

Generate the DROP TABLE Statement

This option controls whether the DROP statement is added to all the scripts or not. If the option is checked, the DROP TABLE statement is added to each file containing the DDL statement for the table. Also, where possible, for other database objects there will be created CREATE or REPLACE statement instead of just CREATE. For example for Oracle instead of:

CREATE PROCEDURE sp_proc
...

will be created

CREATE or REPLACE PROCEDURE sp_proc
...

NOTE: If option "Generate DDL" is not checked this option is disabled.

Omit Schema Names

If No is selected for “Omit schema names in SQL scripts” option, the schema (owner) name is added before the object name in each DDL statement created.
If Yes is selected for “Omit schema names in SQL scripts” option, the schema (owner) name is not added. This allows you to use the default schema (owner) name for the user who loads the DDL.