Export SQL (Tables Menu)

DBExplorer can export data to a SQL file. The export file will contain the SQL for the table creation and insertion of the specified data. The export file may be loaded on the SQL tab of the DBExplorer and executed to recreate the table.

Upon selection of this function, a form is displayed and the export specifications may be defined.

Export Dialog Items

Export table

The name of the currently selected table that is to be exported.

Export file

The name of the destination file. A browse button is provided to allow file selection.

Include table creation

Specifies that the table creation statement should be included in the output SQL file.

Include data

Specifies that the row insertion statements should be included in the output SQL file.

Columns

The name of the columns to be exported. Columns may be excluded by clearing the check box on the appropriate line.

Progress

The progress section shows the record count and a progress bar. A stop button allows the export to be aborted.

When exporting from the Data or SQL tab, only the selected rows are output. Use Select All before exporting to choose all rows of data shown. The Export Data function when other DBExplorer tabs are selected exports all rows in the selected table.