MS SQL Server - Query Designer

Query Designer

1. Open SQL Server Management Studio.
2. Select the database you want to query from in the drop down list of the SQL Editor tool bar, in our case 'NORTHWIND'.
3. Navigate to the Query menu and select the 'Design Query in Editor...' option. Alternatively, press Ctrl+Shift+Q.
4. The Query Designer will load and follow the steps in next section to select the needed tables, then build and test the query.