Archives of the TeradataForum

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

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

Hi,

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

Ulrich

www.data2knowledge.de

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