Archives of the TeradataForum

Message Posted: Thu, 24 Oct 2003 @ 00:24:18 GMT

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

The best you can do to generate ddl is via the SHOW command. I generate this using some simple dynamic sql.

Here is an example...

SELECT 'SHOW TABLE '||TRIM(DATABASENAME)||'.'||TRIM(TABLENAME)||';' FROM DBC.TABLES WHERE DATABASENAME = 'DATABASENAME' AND TABLEKIND = 'T' ORDER BY TABLENAME

This will generate the show commands that you need for your DDL generation. I would run this in Queryman to capture the show statements then copy and paste the show statements back into Queryman and then export these statement.

Make sure you delete the first line once you copy and paste all of the statements or you can add a (title ' ') statement to the above code...

Once you have this in place you can reverse engineer in ERWIN...

Hope this helps...

Chris Coffing
Senior Vice President
Coffing Data Warehousing
www.coffingdw.com

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