Archives of the TeradataForum

Message Posted: Wed, 28 Aug 2003 @ 03:47:53 GMT

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

I think this has been sent before but since I missed the rest of this email thread. Just use these views as a UNIONED sub-select returning databasename,tablename(,columnname if you want at the column level) as a NOT IN list to WHERE clause of DBC.tables WHERE (databasename,tablename,columnname) NOT IN (nested sub-select).

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