Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Query to find Backup tables
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016