 |
 |
Archives of the TeradataForum
Message Posted: Fri, 18 Feb 2005 @ 11:46:18 GMT
| Subj: | | Re: Views referring tables |
| |
| From: | | Dieter Noeth |
Rachana Agarwal wrote:
| | We are going to add some extra columns to few tables. | |
| | All the tables have one or many views defined. ( in other words each table is referred to in multiple view definitions). | |
| | I want to refresh all the views that refer to the tables to which I have added column. | |
| | Is their any system table that would fetch me this info.. or any other way to do this. | |
There've been several treads on it on the forum.
I once posted a SP, at
www.teradata.com/teradataForum/shwmessage.aspx?ForumID=1&MessageID=771
it's with at least some comments ;-)
Dieter
| |
