Archives of the TeradataForum

Message Posted: Mon, 17 Jul 2006 @ 19:12:38 GMT

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

I have 600 tables in a Database with column a x1(columname) .Now I want to know how many tables Having x1(columname) = 20(or any value). Is there any way to find this using Only SQL (Probably Single Query) and Meta tables?

Thanks in advance.

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