Performing Basic Operations with Queries

The following fundamental operations apply to most or all queries.

In This Section

• How to: Create Queries
  Provides steps for creating new queries.

• How to: Open Queries
  Provides steps for opening existing queries.

• How to: Run Queries
  Provides steps for running (or executing) queries.

• How to: Stop a Query
  Provides steps for halting a query while it's running.

• How to: Save Queries
  Provides steps for saving new or revised queries to a database project.

• How to: Verify Queries
  Provides steps for verifying the SQL syntax of a query.

• How to: Modify Queries
  Provides steps for opening an existing query for modification.

• How to: Delete Queries
  Provides steps for deleting queries from projects.

• How to: Copy Queries
  Provides steps for copying the SQL code form one query and pasting it into another.

• How to: Rename Queries
  Provides steps for renaming existing queries

• How to: Discard Changes Made to Queries
  Provides steps for reverting a query to its last changed state.

• How to: Add Tables to Queries
  Provides steps for adding tables and other table-valued objects, such as table-valued functions and views, to queries.

• How to: Remove Tables from Queries
  Provides steps for removing tables and other table-valued objects from the structure of a query.

• How to: Add Columns to Queries
  Provides steps for adding columns to queries.

• How to: Remove Columns from Queries
  Provides steps for removing columns from the structure of a query.

• How to: Create Column Aliases
  Provides steps for creating aliases for columns included in a query.

• How to: Create Table Aliases
  Provides steps for creating aliases for tables included in a query.

• How to: Show Query Properties
  Provides steps for showing properties such as SQL comments, parameter lists, and Top specification.

• How to: Create Queries using Something Besides a Table
  Provides steps for creating queries that use table-valued objects, such as table-valued functions and views.

• How to: Show Column Names in the Diagram Pane
  Provides steps for customizing how tables and table-valued objects look in the Diagram pane.

• How to: 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.

Reference

• Query and View Designer Tools
  Describes the features and capabilities of the Query and View Designer.

• Query Properties
  Describes the properties available for queries.

Related Sections

• Types of Queries
  Lists topics concerning queries you can work with in Query and View Designer.

• Specifying Search Criteria
  Lists topics about how to create queries that return the results set you want.

• Sorting and Grouping Query Results
  Lists topics about how to create queries that return the results set in the organization you want.

• Summarizing Query Results
  Lists topics about how to create queries that summarize results of the involved tables and table-valued objects.

• Designing Queries and Views
  Lists overview topics that provide more detailed links.