To add all columns in a table to a query

In the OpenESQL Assistant, identify a table in the tree view that has been selected for the query and contains the columns you want to add to the query.

Right-click the table name.

Click Select All Columns.