Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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.
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.