Archives of the TeradataForum
Message Posted: Wed, 28 Sep 2011 @ 13:51:25 GMT
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|