Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server
The following fundamental operations apply to most or all queries.
In this section
Article | Description |
---|---|
Create queries | Provides steps for creating new queries. |
Open queries | Provides steps for opening existing queries. |
Run queries | Provides steps for running (or executing) queries. |
Stop a query | Provides steps for halting a query while it's running. |
Save queries | Provides steps for saving new or revised queries to a database project. |
Verify queries | Provides steps for verifying the SQL syntax of a query. |
Modify queries | Provides steps for opening an existing query for modification. |
Delete queries | Provides steps for deleting queries from projects. |
Copy queries | Provides steps for copying the SQL code form one query and pasting it into another. |
Rename queries | Provides steps for renaming existing queries |
Discard changes made to queries | Provides steps for reverting a query to its last changed state. |
Add tables to queries | Provides steps for adding tables and other table-valued objects, such as table-valued functions and views, to queries. |
Remove tables from queries | Provides steps for removing tables and other table-valued objects from the structure of a query. |
Add columns to queries | Provides steps for adding columns to queries. |
Remove columns from queries | Provides steps for removing columns from the structure of a query. |
Create column aliases | Provides steps for creating aliases for columns included in a query. |
Create table aliases | Provides steps for creating aliases for tables included in a query. |
Show query properties | Provides steps for showing properties such as SQL comments, parameter lists, and Top specification. |
Create queries using something besides a table | Provides steps for creating queries that use table-valued objects, such as table-valued functions and views. |
Show column names in the Diagram pane | Provides steps for customizing how tables and table-valued objects look in the Diagram pane. |
Use the Query and View Designer with international data | Describes the features the Query and View Designer provide to make working with international data easier. |
Related content
- Query and View Designer Tools (Visual Database Tools)
- Query Properties (Visual Database Tools)
- Types of queries (Visual Database Tools)
- Specify search criteria (Visual Database Tools)
- Sort and group query results (Visual Database Tools)
- Summarize query results (Visual Database Tools)
- Design queries and views how-to articles (Visual Database Tools)