Export

This tab includes some options relating to SQL export for the document

Target for SQL

This is the dialect that is used to generate SQL in the source sidebar and the default dialect for exporting

It is not used when exporting to JDBC (the correct dialect for the database will normally be used instead)

Tip:

You can also change this setting using the menu at the top of the source sidebar

Drop table before create

This option causes SQLEditor to drop all tables at the beginning of an export. It may make table creation more reliable

Warning

If you check this box then existing tables will be deleted

Add SQLEditor settings table

This option (if available) causes SQLEditor to create an extra table to store document settings and object location iwthin the exported SQL. It is normally unavailable and unchecked.