Edit an SQL statement in the SQL code view

The SQL code view contains the generated SQL code based on changes that you made in the Details area. In some environments, you can edit the generated SQL code in the SQL code view.

The SQL code view acts as a text editor, and includes standard cut, copy, and paste capabilities.

All fields and controls in the Details area are unavailable while you are editing in the SQL code view. You cannot make changes in the Details area until you successfully check the SQL code syntax. This ensures that SQL Assist does not return invalid code. The status box in the SQL code view displays messages indicating the validity of the code when you start making changes and after you check the syntax.

To edit an SQL statement in the SQL code view:

In the SQL code view, you can:

To delete text:

  1. Select the text that you want to delete in the SQL code view.
  2. Press the Delete key on the keyboard, or press Ctrl + x on the keyboard.

To copy text:

  1. Select the text that you want to copy in the SQL code view.
  2. Press Ctrl + c on the keyboard.
  3. Place the cursor in the SQL code view where you want to copy the text.
  4. Press Ctrl + v on the keyboard.

To add new text:

  1. Place the cursor in the SQL code view where you want to insert text.
  2. Type the new text.

Return to Edit an SQL statement