Archives of the TeradataForum

Message Posted: Tue, 30 Dec 2014 @ 12:29:28 GMT

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

<-- Anonymously Posted: Tuesday, December 30, 2014 04:13 -->

Hi Forum,

Does someone has a query to find out all the backup tables in the system which ends with date format.

There is no standard naming convention and the backup tables ends with any of the below strings.

     _YYYYMMDD
     _MMDD
     _YYYYMM
     _DDMM
     _BKP

Thank you and Happy New Year in advance!

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