Output SQL Script File

To specify the output file name, enter it into the Output SQL Script File field, or use the Browse button to select a file. Leave this field blank to view, but not save, the generated output.

Generate DROP Statements Before Each CREATE Statement

Select this option to generate a statement to drop each object before the statement that creates it. This ensures that any existing instance of each object is removed when the output is executed.

Generate DROP SCHEMA

Skip creation of FOREIGN KEYS

Skip creation of FK Indexes as well

Omit Schema Qualifier in Object Names

Select this option to generate unqualified object names in SQL statements.

Generate USE statements

Generate Separate CREATE INDEX Statements

Select this option to create separate statements for index creation instead of including index definitions in CREATE TABLE statements.

Add SHOW WARNINGS after every DDL statement

Select this option to add SHOW WARNINGS statements to the output. This causes display of any warnings generated when the output is executed, which can be useful for debugging.

Do Not Create Users. Only Export Privileges

Select this option to update the privileges of existing users, as opposed to creating new users. Exporting privileges for nonexistent users will result in errors when you execute the CREATE script. Exporting users that already exist will also result in an error.

Don't create view placeholder tables

Generate INSERT Statements for Tables

Select this option if you have added any rows to a table. For more information about inserting rows, see Section 8.1.1, “SQL Query Window”.

Disable FK checks for inserts

Create triggers after inserts