--- title: Perform Basic Operations with Queries ms.custom: seo-lt-2019 ms.date: 01/19/2017 ms.prod: sql ms.prod_service: sql-tools ms.technology: ssms ms.topic: conceptual helpviewer_keywords: - "queries [Visual Database Tools]" - "Visual Database Tools [SQL Server], queries" ms.assetid: 88dbdbfe-bc60-4e11-b338-dbe7f26566d5 author: markingmyname ms.author: maghan ms.manager: jroth ms.reviewer: --- # Perform Basic Operations with Queries (Visual Database Tools) [!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)] The following fundamental operations apply to most or all queries. ## In This Section [Create Queries (Visual Database Tools)](../../ssms/visual-db-tools/create-queries-visual-database-tools.md) Provides steps for creating new queries. [Open Queries (Visual Database Tools)](../../ssms/visual-db-tools/open-queries-visual-database-tools.md) Provides steps for opening existing queries. [Run Queries (Visual Database Tools)](../../ssms/visual-db-tools/run-queries-visual-database-tools.md) Provides steps for running (or executing) queries. [Stop a Query (Visual Database Tools)](../../ssms/visual-db-tools/stop-a-query-visual-database-tools.md) Provides steps for halting a query while it's running. [Save Queries (Visual Database Tools)](../../ssms/visual-db-tools/save-queries-visual-database-tools.md) Provides steps for saving new or revised queries to a database project. [Verify Queries (Visual Database Tools)](../../ssms/visual-db-tools/verify-queries-visual-database-tools.md) Provides steps for verifying the SQL syntax of a query. [Modify Queries (Visual Database Tools)](../../ssms/visual-db-tools/modify-queries-visual-database-tools.md) Provides steps for opening an existing query for modification. [Delete Queries (Visual Database Tools)](../../ssms/visual-db-tools/delete-queries-visual-database-tools.md) Provides steps for deleting queries from projects. [Copy Queries (Visual Database Tools)](../../ssms/visual-db-tools/copy-queries-visual-database-tools.md) Provides steps for copying the SQL code form one query and pasting it into another. [Rename Queries (Visual Database Tools)](../../ssms/visual-db-tools/rename-queries-visual-database-tools.md) Provides steps for renaming existing queries [Discard Changes Made to Queries (Visual Database Tools)](../../ssms/visual-db-tools/discard-changes-made-to-queries-visual-database-tools.md) Provides steps for reverting a query to its last changed state. [Add Tables to Queries (Visual Database Tools)](../../ssms/visual-db-tools/add-tables-to-queries-visual-database-tools.md) 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)](../../ssms/visual-db-tools/remove-tables-from-queries-visual-database-tools.md) Provides steps for removing tables and other table-valued objects from the structure of a query. [Add Columns to Queries (Visual Database Tools)](../../ssms/visual-db-tools/add-columns-to-queries-visual-database-tools.md) Provides steps for adding columns to queries. [Remove Columns from Queries (Visual Database Tools)](../../ssms/visual-db-tools/remove-columns-from-queries-visual-database-tools.md) Provides steps for removing columns from the structure of a query. [Create Column Aliases (Visual Database Tools)](../../ssms/visual-db-tools/create-column-aliases-visual-database-tools.md) Provides steps for creating aliases for columns included in a query. [Create Table Aliases (Visual Database Tools)](../../ssms/visual-db-tools/create-table-aliases-visual-database-tools.md) Provides steps for creating aliases for tables included in a query. [Show Query Properties (Visual Database Tools)](../../ssms/visual-db-tools/show-query-properties-visual-database-tools.md) Provides steps for showing properties such as SQL comments, parameter lists, and Top specification. [Create Queries using Something Besides a Table (Visual Database Tools)](../../ssms/visual-db-tools/create-queries-using-something-besides-a-table-visual-database-tools.md) 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)](../../ssms/visual-db-tools/show-column-names-in-the-diagram-pane-visual-database-tools.md) 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)](../../ssms/visual-db-tools/use-the-query-and-view-designer-with-international-data-visual-database-tools.md) 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)](../../ssms/visual-db-tools/query-and-view-designer-tools-visual-database-tools.md) Describes the features and capabilities of the Query and View Designer. [Query Properties (Visual Database Tools)](../../ssms/visual-db-tools/query-properties-visual-database-tools.md) Describes the properties available for queries. ## Related Sections [Types of Queries (Visual Database Tools)](../../ssms/visual-db-tools/types-of-queries-visual-database-tools.md) Lists topics concerning queries you can work with in Query and View Designer. [Specify Search Criteria (Visual Database Tools)](../../ssms/visual-db-tools/specify-search-criteria-visual-database-tools.md) Lists topics about how to create queries that return the results set you want. [Sort and Group Query Results (Visual Database Tools)](../../ssms/visual-db-tools/sort-and-group-query-results-visual-database-tools.md) Lists topics about how to create queries that return the results set in the organization you want. [Summarize Query Results (Visual Database Tools)](../../ssms/visual-db-tools/summarize-query-results-visual-database-tools.md) 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)](../../ssms/visual-db-tools/design-queries-and-views-how-to-topics-visual-database-tools.md) Lists overview topics that provide more detailed links.