continue question:(on table newly changed)

Database
Enthusiast

continue question:(on table newly changed)

I just want to find the tose tables or views definition changed recently not the data. How would I do that? Thank you very much!
2 REPLIES
Enthusiast

Re: continue question:(on table newly changed)

You can query the dbc.tvm table or the dbc.tables view with a condition on the lastAlterTimestamp.

Enthusiast

Re: continue question:(on table newly changed)

sel * from dbc.tvm
where LastAlterTimeStamp > (CURRENT_TIMESTAMP - interval '2' day )
AND CreateTimeStamp <> LASTALTERTIMESTAMP;

THIS WILL GIVE YOU THE TABLES AND VIEW WHICH ARE ALTERED WITH IN THE SPAN OF LAST TWO DAYS