remove-columns-from-queries-visual-database-tools.md

title	Remove Columns from 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	removing columns queries [SQL Server], columns deleting columns dropping columns
ms.assetid	6d9819b8-ee2f-4838-9713-c5e3ad37ab46
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Remove Columns from Queries (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] If you no longer want to use a column in a query, you can remove it. If you do, the Query and View Designer removes references to the column in the select list, the sort specification, the search criteria, SQL Pane, and any grouping specifications.

Note

If you want to remove a column from just the output of a Select query, you can do so without removing it from the query altogether. For details, see Remove Columns from Query Results (Visual Database Tools).

To remove a column from the query

• In the Criteria Pane, select the grid row containing the column you want to remove and then press DELETE.

  -or-

• Remove all references to the column in the SQL Pane.

See Also

Add Columns to Queries (Visual Database Tools)
Sort and Group Query Results (Visual Database Tools)
Summarize Query Results (Visual Database Tools)
Perform Basic Operations with Queries (Visual Database Tools)