Archives of the TeradataForum
Message Posted: Tue, 21 Dec 2010 @ 10:08:35 GMT
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 !
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|