How to: Remove Columns from Queries
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 How to: Remove Columns from Query Results.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.
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
Tasks
How to: Add Columns to Queries