Opening the SQL Builder
The Create A New SQL Statement wizard and the SQL Builder both provide a visual interface for creating and executing SQL statements. You can use the wizard to create a simple SQL statement, or you can use the SQL Builder, which supports a wider range of statements. Statements generated by these tools are saved in a file with the extension .sqx. For more information, refer to the related information.
Prerequisite: Before you create your SQL statement, do one of the following:
- Define a database directly in the Data Definition view,
- Connect to a database and copy the data definitions to a project.
You can open the SQL Builder in any of the following ways:
- Create a new SQL statement through the wizard.
- Click File > New > Other.
- In the New window, expand the Data node, click SQL Statement, and then click Next.
- In the wizard, click Create an SQL resource and invoke the SQL Builder. After you work through the remaining pages in the wizard and click Finish, the wizard closes, and the SQL Builder opens.
- Create a new SQL statement manually.
- Switch to the Data perspective, and then click the Data Definition tab.
- In the Data Definition view, expand the project or folder that contains your database, and then expand the database nodes until you see the Statements folder.
- Right-click the Statements folder and then, on the pop-up menu, click New > and the type of statement that you want to create. Your statement automatically opens in the SQL Builder.
- Open an existing SQL statement.
- Switch to the Data perspective, and then click the Data Definition tab.
- In the Data Definition view, expand the project or folder that contains your database, and then expand the database nodes until you see the Statements folder.
- Expand the Statements folder, and then double-click the statement that you want to open in the SQL Builder.
Parent topic
SQL Builder
Related concepts
Create A New SQL Statement wizard
SQL Builder
Related tasks
Editing an SQL statement