Archives of the TeradataForum
Message Posted: Wed, 03 Jan 2007 @ 17:08:51 GMT
| Subj: || || Re: Username and last modified information for a particular table |
| From: || || Geoffrey Rommel |
| ||how can we see in Teradata the last update/inserts and access information with time stamp and the user id used for this purpose for a
particular table?|| |
I don't know of any RDBMS that automatically tracks the last update, etc., on every column of every row of every table. This would probably add
a lot of overhead for relatively little value; hence it is left up to the customer to track these things when they are really needed.
| ||Why we do not always have entry on DBC.Tables for all the tables/views? What we need to do to have entry on this view for all the
tables of the databases (entry for LastAlterName. LastAlterTimeStamp, LastAccessTimeStamp).|| |
I believe your question is: "Why don't LastAlterName and LastAlterTimeStamp change whenever anyone changes any data in the table?" The
LastAlter columns track changes to the structure of the table (columns added or dropped, for instance), not changes to the data.
| ||Is there any way we can find these from DBQL for a particular table?|| |
Yes, if DBQL is logging everything, you can infer when changes took place to the data, but there are complications. (1) Most update statements
change more than one row, so it may be difficult or impossible after the fact to determine exactly which rows were changed. (2) FastLoad and
MultiLoad do not perform ordinary insert statements, so in general you can't tell which rows were inserted when.
If tracking changes to individual rows is important to you, you'll have to include updates to the user ID and timestamp in your