Archives of the TeradataForum

Message Posted: Mon, 08 Nov 2004 @ 19:32:09 GMT

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

If you have Teradata Administrator you can select the Table (in the upper grid) then choose the 'References' menu from the right click (popup) menu.

Otherwise (if you have access to the dbc.TVM and dbc.DBase tables) you can run the following query:

     SELECT  DatabaseName,TVMName,TableKind
       FROM  dbc.TVM T,dbc.dbase D
       WHERE D.DatabaseId=T.DatabaseId
         AND CreateText LIKE '%"#D#"."#T#"%' (NOT CS)
       ORDER BY 1,2

Where #D# is the database name and #T# is the table name of the table you are looking for.

(Both of these will find Views, Macros, Triggers and Join Indexes that reference the Table.)

Mike Dempsey
Teradata Client Tools

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