Archives of the TeradataForum

Message Posted: Thu, 20 Nov 2003 @ 17:22:54 GMT

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

A variation / enhancement to the generation of the show table statements Bill just referred to:

select 'show table ' || trim(databasename) || '.' || trim(tablename) || ' ;'
  from dbc.tables
 where tablekind = 't'
   and databasename in
       ('mydatabase1','mydatabase2',...)
   and tablename not in
        (select trim(childtable) || '_' || trim(indexid)
           from dbc.all_ri_children
        )
 order by 1;

Put your database list in the "mydatabase" stuff.

I use this or some variation thereof.

I also use WinDDi; it's excellent.

Don

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