Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Feb 2003 @ 03:49:24 GMT

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

Subj:   Re: Extracting DDL of a whole database
From:   Narayan Murthy K S

You could try something like this:

sel createtext from dbc.tvm
where databaseid = (sel databaseid from dbc.dbase
                      where databasename='dbc');

Above I have used 'dbc' as the databasename, you could specify your own databasename. You could also restrict the kind of object definition that you are trying to retrieve, based on the field dbc.tablekind.

Hope this helps.

Narayan Murthy K S
Wipro Technologies

  <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: 28 Jun 2020