Archives of the TeradataForum

Message Posted: Tue, 07 May 2002 @ 12:09:22 GMT

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

select
    (trim (databasename)||'.'||trim(tablename)) as tablename
   , count(*)
from
    dbc.tables
group by 1
order by 1

lg Armin

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