Databases Reference
In-Depth Information
When browsing results are displayed, any column header can be clicked to sort
on this column, even if it is not part of an index. Let us click on the
author_id
column header.
We can confirm that the sorting has occurred, by watching the SQL query at the top
of screen; it contains an
ORDER
BY
clause.
We now see a small triangle pointing upwards beside the
author_id
header. This
means that the current sort order is 'ascending'. Hovering the mouse over the
author_id
header makes the triangle change direction, to indicate what will happen
if we click on the header again—a sort by descending
author_id
values.
Another way to sort is by key. The
Sort
dialog shows all the keys already defined.
Here we see a key named
PRIMARY
—the name given to our primary key on the
isbn
column when we checked
Primary
for this column at creation time:
Search WWH ::
Custom Search