Performing Basic Operations with Queries (Visual Database Tools)

The following fundamental operations apply to most or all queries.

In This Section

• How to: Create Queries (Visual Database Tools)
  Provides steps for creating new queries.

• How to: Open Queries (Visual Database Tools)
  Provides steps for opening existing queries.

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

• How to: Stop a Query (Visual Database Tools)
  Provides steps for halting a query while it's running.

• How to: Save Queries (Visual Database Tools)
  Provides steps for saving new or revised queries to a database project.

• How to: Verify Queries (Visual Database Tools)
  Provides steps for verifying the SQL syntax of a query.

• How to: Modify Queries (Visual Database Tools)
  Provides steps for opening an existing query for modification.

• How to: Delete Queries (Visual Database Tools)
  Provides steps for deleting queries from projects.

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

• How to: Rename Queries (Visual Database Tools)
  Provides steps for renaming existing queries

• How to: Discard Changes Made to Queries (Visual Database Tools)
  Provides steps for reverting a query to its last changed state.

• How to: Add Tables to Queries (Visual Database Tools)
  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 (Visual Database Tools)
  Provides steps for removing tables and other table-valued objects from the structure of a query.

• How to: Add Columns to Queries (Visual Database Tools)
  Provides steps for adding columns to queries.

• How to: Remove Columns from Queries (Visual Database Tools)
  Provides steps for removing columns from the structure of a query.

• How to: Create Column Aliases (Visual Database Tools)
  Provides steps for creating aliases for columns included in a query.

• How to: Create Table Aliases (Visual Database Tools)
  Provides steps for creating aliases for tables included in a query.

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

• How to: Create Queries using Something Besides a Table (Visual Database Tools)
  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 (Visual Database Tools)
  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 (Visual Database Tools)
  Describes the features the Query and View Designer provide to make working with international data easier.

Reference

• Query and View Designer Tools (Visual Database Tools)
  Describes the features and capabilities of the Query and View Designer.

• Query Properties (Visual Database Tools)
  Describes the properties available for queries.

Related Sections

• Types of Queries (Visual Database Tools)
  Lists topics concerning queries you can work with in Query and View Designer.

• Specifying Search Criteria (Visual Database Tools)
  Lists topics about how to create queries that return the results set you want.

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

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

• Designing Queries and Views How-to Topics (Visual Database Tools)
  Lists overview topics that provide more detailed links.