Using SQL Server Enterprise Manager
SQL Query Analyzer can be started from SQL Server Enterprise Manager.
In SQL Server Enterprise Manager, on the Tools menu, click SQL Query Analyzer to run SQL Query Analyzer. With SQL Query Analyzer, users can interactively design and execute queries.
SQL Server Enterprise Manager also includes the Query Designer, a graphical user interface (GUI) tool for designing queries used in specific objects:
- In the console tree, in the database you are working on, right-click Views, and then click New View. Query Designer can be used to design the SELECT statement for the view. For more information, see Creating Views.
- In DTS Designer, open a DTS package and add an Execute SQL task, and then click Build Query to access the DTS Query Designer. For more information, see DTS Query Designer.
- In the right pane, right-click a table, click Open Table, and then click Return all rows to see all the rows in the table. Query Designer can be used to change the query to see specific rows. For more information, see Performing Basic Operations with Queries.
The Query Designer window has four separate panes for specifying or displaying different items associated with a query.
| Pane | Description |
|---|---|
| Diagram | Has a diagram showing the tables referenced in the query. The diagram shows all columns for each table and checks the columns used in the result set. |
| SQL | Shows the SQL statement syntax. |
| Grid | Shows the details of the result set columns, such as name, data type, and size. |
| Results | Shows the result set returned by the last query execution. |
For more information about using Query Designer panes, see Query and View Designer Layout.