Edit

Share via

Perform Basic Operations with Queries (Visual Database Tools)

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