All Forums Enterprise
UPENDRA.MISHRA@+91 9776055574 33 posts Joined 01/08
06 Oct 2009
Table alter timestamp

Is there any metadata table/view where one can find the last modification time of the table.
If we alter a table to add a new column, or drop an existing column, or any chnage to table structure, in Oracle, there is a metadata table (all_objects) where we can find the
last modification timestamp.
I am looking for the same functionality in TERADATA.

Please suggest.

Jimm 165 posts Joined 09/07
06 Oct 2009

DBC.Tables.LastAlterTimestamp

give the date/ time that DDL was run on the table - eg Create/ Alter/ Create or Drop Index, etc

You must sign in to leave a comment.