Exporting SQL statements from scripts in the SQL and XQuery editor

When you are working with an SQL script in the SQL and XQuery editor, you can export one or more of the SQL statements in the script.

Before you begin

The script that contains the SQL statements that you want to export must be open in the SQL and XQuery editor.

About this task

You can export all the SQL statements in the script or you can export only the statements that you select. The exported SQL statements are saved in a text-based file that, by default, has the same name as the SQL script, including the extension .sql.

Procedure

To export SQL statements from a script in the SQL and XQuery editor:

  1. If you want to export only some of the SQL statements in the script, select one or more of the statements. The editor does not validate your selection for completeness.
  2. In the top border of the editor, click Export.
  3. In the Export to Directory window, browse to the appropriate directory and then, optionally, specify the name of the file to contain the exported SQL statements.

Results

The file that is created contains the SQL statements that you exported. If you make changes in the SQL and XQuery editor to SQL statements that you exported, the statements in the exported file are not updated with those changes.

Feedback