Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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

           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 !


Samikkumar shah

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023