Archives of the TeradataForum

Message Posted: Tue, 18 Jul 2006 @ 09:50:56 GMT

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

Hi Arumugam Murugesan

Yes there is a query to find out the different table names which has a particular column name. And the query for the above is as follows

     select tablename
        from dbc.columns where columnname='employee_number'

But I don't know how to find out the list of tables which has a particular value for a column. And please share with me if you get it.

With Regards ,

Girish Chandra Nayak,
Software Engineer

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