Visual Database Tools
Creating a Query
To create a new query
- In the SQL Server Enterprise Manager, right-click any table or view that will be included in the query.
- On the shortcut menu, point to Open Table and choose Query, or point to Open View and choose Query.
The Query Designer appears with the table or view already present on the Diagram Pane.