To create a query tab...

  1. Right-click on the connection and select Query

    This will open a query tab in the middle pane.
  2. Expand the connection and drag a table from the connection into the query pane.
  3. This will initiate the query: 'select all columns from the table'.
  4. Dragging a column within the table into the query pane will add an 'order by' clause to the SQL script
  5. The 'order by' clause is displayed in the query pane:

    Note

    It is possible to drag more than one column into the query pane, as long as the columns come from the same table.

  • No labels