Databases Reference
In-Depth Information
We can see that under the
Tracking report
header, a list of the statements that are
tracked is shown. Then we have a selector to determine if we want to see on the
report the statements corresponding to:
•
Structure and data
•
Structure only
•
Data only
We can also specify the range of dates and times for which we want to produce the
report. It's also possible to indicate which users we want to report on (an asterisk
represents all users).
The main part of the report consists of the statements themselves; here we see four
statements. The first statement is a
DROP TABLE
statement, which would be useful
to create this table anew should we need to export this version and import it back.
The second statement (
CREATE TABLE
) contains the snapshot that was taken when
version 1 was initiated. Then we see the
ALTER TABLE
and
UPDATE
statements that
correspond to the actions we performed as a test.
How to export a structure will be covered in the
Exporting a version
section later in
this chapter.
Determining tracking status
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:
Search WWH ::
Custom Search