Archives of the TeradataForum

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

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

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