Remove columns from query results (Visual Database Tools)

Applies to: SQL Server

If you're using a column in a Select query but don't want to display it in the result set (that is, you don't 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.

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 (Visual Database Tools).

Related content

• Add columns to queries (Visual Database Tools)
• Remove columns from 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)