Archives of the TeradataForum

Message Posted: Mon, 11 Mar 2002 @ 20:26:01 GMT

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

<-- Anonymously Posted: Monday, March 11, 2002 14:32 -->

One method I have used is to search in the column dbc.tables.requesttext, since this column has view and macro definations.

Say if you are searching if Tbl1 is used in any view, you would use the sql:

select * from dbc.tables
where requesttext like '%tbl1%';

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