Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Dec 2010 @ 10:08:35 GMT


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


Subj:   Help On Teradata Administartor part
 
From:   Samikkumar Kiritkumar Shah

Hi Friends,

We have main database D_DEvlopmennt then inside it we have D_deverr, d_devland, ...etc so the tree will be like D_Devlopment

     D_Deverror
     D_DevLand
        DD_LND
           DD_lnd_001
           DD_Lnd_002   like _020

Now in each database I am having lot of tables if I want to copy all the table definition in one shot means if total I have 500 table and I want to take(export) all the tables definition in one file....can we do it ?

If yes , can ay one help me and give me steps to do it.

Reason : As we are creating development box we are getting lot of changes in tables so every time we are dropping all tables individually going all databases..if we can export then we can do those changes and run whole script as one Bteq.

Any suggestion will be most welcome !


Thanks,

Samikkumar shah



     
  <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