Table alter timestamp

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Table alter timestamp

Rate Topic

Display Mode

Topic Options

Author

Message

UPENDRA.EX!LANT

Posted 10/6/2009 11:52:32 AM

Forum Member

Group: Forum Members
Last Login: 10/6/2009 11:47:18 AM
Posts: 27, Visits: 76

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.

*

Post #17040

jimm

Posted 10/6/2009 12:47:32 PM

Supreme Being

Group: Forum Members
Last Login: Today @ 2:07:30 AM
Posts: 112, Visits: 264

DBC.Tables.LastAlterTimestamp

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

Post #17041

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:16am