To create a query tab...
- 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
- Expand the connection and drag a table from the connection into the query pane
REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery3.png
- This will initiate the query: 'select all columns from the table'
REPLACE WITH THIS IMAGE: Images/connections/draggingtabletoquery4.png
- 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
- 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