Archives of the TeradataForum

Message Posted: Mon, 08 Nov 2004 @ 20:32:52 GMT

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

<-- Anonymously Posted: Monday, November 08, 2004 14:29 -->

Teradata Administrator will show you this... The SQL behind the right click request is:

     SELECT DatabaseName,TVMName,TableKind AS "Type"
      FROM dbc.TVM T,dbc.dbase D
     WHERE D.DatabaseId=T.DatabaseId
     AND CreateText LIKE '%"YOURDATABASE"."YOURTABLE"%'
     ORDER BY 1,2

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