Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

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.


Convert cascade referential integrity constraint to no action

If checked all Foreign keys with CASCADE action would convert to Foreign Keys with NO ACTION action.


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/users-guide/wizard/specify-ddl-data/db_options/ddl_options/sql_scripts.txt · Last modified: January 27, 2017, 04:44:25 AM by anastasiya.shpakava
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement