Perform Basic Operations with Queries (Visual Database Tools)

The following fundamental operations apply to most or all queries.

In This Section

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

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

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

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

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

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

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

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

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

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

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

• 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.

• Remove Tables from Queries (Visual Database Tools)
  Provides steps for removing tables and other table-valued objects from the structure of a query.

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

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

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

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

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

• 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.

• 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.

• 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.

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

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

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

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