Let us cover all of the places in the interface where we can ascertain the tracking activity for a table. First, in Table
view, we can see a message positioned under the menu tabs, stating that tracking is activated for this table, as shown in the following screenshot:
In the Tracking panel itself, a Status column tells us that tracking is either active or not active for the latest version. In fact, when we create another version for the table, we will see that only the current version can have an active tracking status, as previous versions now only contain historical data.
In Database
view, each table that is tracked by the system (with an active or not active status) is shown with the icon of an eye either in color or grayed out, depending upon its status. In the following example, the eye is in color:
This eye icon is clickable and brings us to the Tracking panel for this specific table.
Finally, in Database
view, the Tracking menu provides us with an overview of all the tables. First the tracked tables are presented, then the untracked ones. For either category, we have links to see more information or to start tracking:
For the tracked tables, the following table gives a breakdown of the information presented, along with the available links:
Title or link |
Description |
---|---|
Database |
In which database the table is located |
Table |
Which table is tracked |
Last version |
The latest tracked version; it's interesting to see how many versions exist for this table |
Created |
When was this version created |
Updated |
When was the last tracked statement stored for this table |
Status |
Active or not active |
Action |
The Drop link can be used to remove all tracking (refer to the Deleting tracking information section later in this chapter) |
Show | Versions |
Enters |
Show | Tracking report |
Enters |
Show | Structure snapshot |
Enters |
For the untracked tables, a Track table link allows us to enter Table
view for this table, directly in the Tracking panel, hence creating version 1 in order to start the tracking mechanism.
From the Tracking page of a specific table, the Deactivate now button (which acts as a toggle, and changes to Activate now) is the one to use if we wish to stop (temporarily or permanently) further storing of the tracked statements. Past statements that were stored remain untouched in the tracking data related to the current version.
18.191.237.79