Use this dialog box to modify how the SQL format is displayed. Figure 1 shows the default SQL output. Depending on your needs, you may want to check or uncheck some options.

Add drop table statement

When this box is checked, a DROP TABLE statement is added to the output. This will force the SQL database to remove any existing table first. Only use this option in conjunction with the create table option.

Add create table statement

When this box is checked, a CREATE TABLE statement is added to the output. If there is a chance the table already exists, be sure to use the drop table statement. Otherwise, this will create a table suitable to hold the report data in.

Use extended insert statement

If your SQL database will accept a combined INSERT statement, check this box. This will usually speed up the importing process of this file.

Figure 1. Position Summary report output as a SQL file using the default settings.

 

---

Page url: http://www.helpandmanual.com/help/index.html?wmh_sql.htm