Archives of the TeradataForum

Message Posted: Wed, 26 Nov 2008 @ 10:16:18 GMT

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

     sel
     a.infokey,
     a.infodata,
     b.num_tables

     from
         dbc.dbcinfo a ,
         (sel count(*) num_tables  from dbc.tables where tablekind='T') b
     ;

Is it the answer of your query?

Polesh

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