Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2010 @ 11:50:42 GMT

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

Ravi,

You can use Teradata System Emulation Tool(TSET), if you have necessary access to use it.

OR the below as example:-

     SELECT  'SHOW TABLE ' ||TRIM(DATABASENAME)||'.'||TRIM(TABLENAME)||' ; '
     FROM DBC.TABLES
     WHERE DATABASENAME IN ('INF_DWH_DB','DWH_DB','DWH_STAGING')
     AND TABLEKIND IN( 'T' ,'O')
     ORDER BY DATABASENAME;

Check if this return the total count of your tables. You can use the o/p of this sql in bteq export and extract the DDL.

P.S :- Use the .set width to the max you can , in your export.

Rgds,

Rishi

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