Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 09 Dec 2011 @ 16:01:49 GMT

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

Subj:   Re: Capture output from "show select *" into a table
From:   td newsgroup


no easy way to do this.

A Java Application with JDBC can do it. exec the show, retrieve the DDL and write them into a table.

But there are some things to consider

1. Not all DDL contain the DB name of the Object.

2. Some DDLs might be incomplete



  <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