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