Archives of the TeradataForum

Message Posted: Mon, 27 Feb 2006 @ 16:27:27 GMT

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

Hi,

Use this query

     SELECT 'Show Table ' || TRIM(BOTH FROM DATABASENAME) || '.' || TRIM(BOTH
     FROM TABLENAME) || ';'
     FROM DBC.TABLES
     WHERE DATABASENAME = 'REAPP' AND TABLEKIND ='t'

THis will give you DDLs for Each table, run this in SQL assistant and before running turn the option

Export Result from File Menu.

A file with all the DDLs will be created.

HTH

Kind Regards,

Affan

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