Archives of the TeradataForum

Message Posted: Wed, 29 Jan 2014 @ 20:13:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi James,

The dbms doesn't keep a full history of changes to table definitions. Column LastAlterTimeStamp and LastAlterUserName will give you the last change details, but if the index changes were not the last change then you cannot find that information.

Regards,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>