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).
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.