SQL and XQuery statement creation in the SQL editor

You can create SQL and XQuery statements by using the SQL editor in the Data perspective.

The SQL editor supports any statements that can be run by the database to which you are connected. You can create single or multiple SQL statements, single or multiple XQuery statements, XQuery statements that are nested in SQL statements, and SQL statements that are nested in XQuery statements.

You can open the SQL editor from any of the following places in the workbench:

The File menu
A data project
A physical data model in a data design project
A database connection
The Database Explorer toolbar

Creating SQL and XQuery statements in the SQL editor by using the File menu
You can use the File menu to create SQL and XQuery statements in the SQL editor.
Creating SQL and XQuery statements in the SQL editor by using a data project
You can use the SQL Scripts folder in a data project to create SQL and XQuery statements in the SQL editor.
Creating SQL and XQuery statements in the SQL editor by using a database connection
You can use a database connection in the Database Explorer view to create SQL and XQuery statements in the SQL editor.
Creating SQL and XQuery statements in the SQL editor by using the Database Explorer toolbar
You can use the Database Explorer toolbar to create SQL and XQuery statements in the SQL editor.