How to find when the table was updated in Teradata Database?

Database
Enthusiast

How to find when the table was updated in Teradata Database?

Hi All,
i want to know, How to find when the table was updated in Teradata Database.
4 REPLIES
Enthusiast

Re: How to find when the table was updated in Teradata Database?

Try checking the lastaccesstimestamp in dbc.tables table or try searching for update table queries in access log and query log tables
Enthusiast

Re: How to find when the table was updated in Teradata Database?

LastAccessTimeStamp cotains only null value, when i execute SQL

Sel *
From dbc.tables

Anyway thanks for your reply.
Enthusiast

Re: How to find when the table was updated in Teradata Database?

The system does not maintain LastAccessTimestamp unless the "object use counts" feature is activated. Use the DBSCONTROL utility to turn it on. As I understand it, this would give you the time the table was last accessed, not necessarily when it was last updated.

An alternative solution would be to define a trigger on the tables of interest and use the trigger to update an audit table.
Enthusiast

Re: How to find when the table was updated in Teradata Database?

Hi dear,

try this one

sel * from dbc.DBQLSqlTbl

where SqlTextInfo like 'UPDATE %tablename%'

i guess it will work.

thanks