Remove Columns from a Query

If you no longer want to use a column in a query, you can remove it. If you do, the Query 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.

Remove a column from the query

1. In the Database window, click Queries   under Objects, click the query you want to open, and then click Design on the database window toolbar.
2. In the Grid 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.

Remove a column from query output

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.

1. In the Database window, click Queries   under Objects, click the query you want to open, and then click Design on the database window toolbar.
2. In the Diagram pane, clear the check box next to the name of the column you want to remove.

   -or

   In the Grid 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.