You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

To create a query tab...

  1. Right-click on the connection and select Query

REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery1.png
This will open a query tab in the middle pane
REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery2.png

  1. Expand the connection and drag a table from the connection into the query pane

REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery3.png

  1. This will initiate the query: 'select all columns from the table'

REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery4.png

  1. Dragging a column within the table into the query pane will add an 'order by' clause to the SQL script

REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery5.png

  1. The 'order by' clause is displayed in the query pane:

REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery6.png

Note

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

REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery7.png

  • No labels