Creating SQL statements in the SQL editor by using a data project

You can use the SQL Scripts folder in a data development project or a data design project to create an SQL statement in the SQL editor.

The SQL editor supports any statement that can be run by the database to which you are connected. Any statement that you create is stored in a file with the extension .sql.

Prerequisite: Before you create an SQL statement by using a data project, create a data development project or a data design project in the Data Project Explorer view.

To create an SQL statement in the SQL editor by using a data project:

  1. Open the Data perspective.
  2. In the Data Project Explorer view, expand the data development project or the data design project, right-click the SQL Scripts folder, and then click New > SQL Statement on the pop-up menu.
  3. Complete the New SQL Statement wizard and then click Finish. On the Statement Type page of the wizard:
    1. Under Edit using, click SQL editor.
    2. In the Statement template field, select the template for the type of statement that you want to create. If you do not want to use a template, select None. If you want to see sample statements, select Sample statements.
    The SQL statement is added to the SQL Scripts folder of the data project and opens in the SQL editor.
  4. Complete the SQL statement in the SQL editor, and then save the statement.
Related concepts
SQL editor
Related tasks
Changing the SQL statement terminator

Feedback