How to Execute SQL Queries

To generate execute SQL queries in the designer, you can use the [SQL Editor tab]../Functionality%20Reference/SqlEditor.htm). This editor lets you edit SQL queries and SQL files and execute them as a single statement or as a batch. You can view resultsets returned by the executed SQL queries in the bottom half of the [SQL Editor tab]../Functionality%20Reference/SqlEditor.htm).

After exporting DDL SQL scripts, the designer will offer the choice to open the generated script directly in a new SQL Editor tab and you can execute it immediately.

To quickly create SELECT statements for tables, views and table-valued functions in the meta-data of the project, right-click them in the Catalog explorer and select one of the Create Select Query options. The created queries are copied to the clipboard and you can for instance paste them in a SQL Editor tab to execute them.