"foo"."bar"" />
Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2005 @ 13:57:49 GMT

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

Subj:   Re: Views referring tables
From:   Dieter Noeth

Glen Blood wrote:

  This will work, but don't forget to look for the views that use the views on the modified tables.  

And those views without qualified tablename, e.g. only 'table' instead of 'database.table'.

  I had to do something similar recently. I built a table and put the modified databases and tables in it and then wrote a recursive query adding to the table until I wasn't adding any rows.  

  I then dumped the table and went to work.  

  You will pick up some false positives.  

  If you are searching for table TALPHA and also have TALPHA1  

At least that can be avoided by using tvm.createtext instead (It's the code you get when you "SHOW QUALIFIED SEL ..."). Whithin that column the requesttext is fully resolved and surrounded by double quotes, e.g. foo.bar -> "foo"."bar"


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023