Archives of the TeradataForum

Message Posted: Tue, 22 Mar 2011 @ 10:28:30 GMT

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

This is what I had to do some time ago, for a similar issue :

     SEL DATABASENAME, TABLENAME
     From dbc.columns
     Where chartype = 2
     AND DATABASENAME LIKE 'WHATEVER%'
     GROUP BY 1,2
     Order by 1,2;

Regards

David Clough
Database Developer
Database Design Group

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