Last updated date and time of any table in Teradata

UDA
Fan

Last updated date and time of any table in Teradata

Can somebody help me in getting the Last updated date and time of any table in Teradata Database?
2 REPLIES
Enthusiast

Re: Last updated date and time of any table in Teradata

Hi Hardik,

Try this...

SELECT TABLENAME, LASTALTERTIMESTAMP FROM DBC.TABLES
-- WHERE DATABASENAME = 'MYDB' -- OPTIONAL
ORDER BY LASTALTERTIMESTAMP DESC

Thanks,
Toad
Fan

Re: Last updated date and time of any table in Teradata

Hi Toad,

I think the above code would give me when the table was last altered and not last updated with the data. It was a useful information but still waiting for the answer to know how i can know when the table was last updated and not altered