Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Generate ddl
 
From:   Chris Coffing

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023