Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2010 @ 09:58:18 GMT


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


Subj:   Re: ARC/RESTORE: - Copy database with No data.
 
From:   Singh, Sudhansu Sekhar

Easy solution coming in mind:

1) fire "Help database" command in a batch file to get all the tables/objects in a file.

2) get the results file, edit it with appending "create table ....". Make the complete DDL with "NO DATA".

3) run this file in target database.


Little to do though.


regards,

Sudhansu



     
  <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: 15 Jun 2023