Archives of the TeradataForum
Message Posted: Fri, 18 Feb 2005 @ 12:28:21 GMT
The following will "probably" give you what you want - but I don't think it will guarantee getting all the views in question. If you have nested views, you would have to continue on with this logic, parsing the requesttext for the view name.
Select * From dbc.tables Where requesttext like '%databasename.tablename%' and tablekind = 'v' ;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|