All Forums UDA
UpaMishra 35 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 298 posts Joined 09/07
06 Oct 2009

DBC.Tables.LastAlterTimestampgive 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.