Databases Reference
In-Depth Information
Quickly accessing tracking information
When we are in the
Tracking
panel for one table, a shortcut dialog allows us to go
directly to the
Tracking
panel of any other tracked table.
To explore this feature, let us now create version 1 of the
book
table. After this is
done, we examine the drop-down list next to
Show versions
button, as shown in the
following screenshot:
This list is similar to what we would see in the
Tracking
panel for database
marc_
book
when looking at the
Tracked tables
portion, but without the need to go back to
this panel.
Deleting tracking information
A feature of the tracking system that might not be evident is that tracking
information for all versions of a table, and thus for its whole lifespan, is still
kept when the corresponding table is dropped. The reason is to keep the history
information intact should we happen to create a table with the same name later on.
Let us do a copy of the
author
table (refer to
Chapter 9
if needed), and name it
author_copy
. We then activate tracking on this new table. The last operation is to
drop this
author_copy
table. Even if we no longer see it in the normal list of tables,
it's different in the
Tracking
panel for database
marc_book
.
Search WWH ::
Custom Search