Archives of the TeradataForum

Message Posted: Wed, 28 Sep 2011 @ 13:51:25 GMT

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

Hi,

Does anyone know of a relatively easy way to derive all the View Names (or Table Names) referenced within a View, by any chance ?

So, if we have a View like this :

     CREATE MYVIEW
     AS
     SEL A.KEY, B.*
     FROM ATABLE A
      INNER JOIN BTABLE B
     WHERE A.KEY= B.KEY
     ;

I want to bring back that MYVIEW references Views/Tables 'ATABLE' and 'BTABLE'

So, basically, I need to explode the Views (or Tables) that make up the definition of MYVIEW.

Any ideas ?

Regards

David Clough
Senior Database Designer
Database Design Group

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