You can use the SQL and XQuery editor to modify SQL statements that you specified in the SQL Query Builder and SQL and XQuery statements that you created in the SQL and XQuery editor.
Prerequisite: To modify a statement in the SQL and XQuery editor, the statement must exist in a data project in the Data Project Explorer view. In a data design project, the SQL statement can be located in either the SQL Scripts folder or the SQL Statements folder in a physical data model.
To modify an SQL or XQuery statement in the SQL and XQuery editor: