Archives of the TeradataForum
Message Posted: Fri, 18 Feb 2005 @ 13:57:49 GMT
| 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"