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:
To copy text:
To add new text: