Share via


How to: Remove Columns from Query Results

If you are using a column in a Select query but do not want to display it in the result set (that is, you do not want it in the query's select list), you can remove it from output. After you remove the column from the query's output, you can still use it in search conditions or as a sorting field.

Note

If you want to remove a column from the query altogether, see How to: Remove Columns from Queries.

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 Customizing Development Settings in Visual Studio.

To remove a column from the query output

  • In the Criteria Pane, clear the check box in the Output column for the data column you want to remove. (If you want to add the column back to the query output, you can check the Output column again.)

    -or-

  • Remove the column from the output list in the SQL pane.

See Also

Tasks

How to: Add Columns to Queries

How to: Remove Columns from Queries

Other Resources

Sorting and Grouping Query Results

Summarizing Query Results

Performing Basic Operations with Queries