Archives of the TeradataForum

Message Posted: Tue, 21 Dec 2010 @ 10:51:41 GMT

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

Hello Samik,

You can try below one

     SEL
      ' show table ' || databasename ||'.'||tablename ||';'
      FROM dbc.tables
      WHERE databasename='Databasename'

And get all the SQL's and export that output to a txt file.

Might be useful.

Regards,

Minal Vankadari

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