 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Jul 2009 @ 16:55:02 GMT
| Subj: | | Re: Drop column from view |
| |
| From: | | Thomas Buehlmann |
| | "If tables referenced by a view are modified to add or remove columns, or change data types of existing columns, then attempts > to access
the view can result in error messages or unexpected results. This is true whether the view references table columns by name or by SELECT
*." | |
| | I'm surprised that a) data type changes would matter to views and b) the database's response could be "unexpected results" rather than
throwing an error. | |
Think of type changes in the light of views that utilize joins. As for the unexpected results; I think the reason may be that the views are
preparsed to avoid having to parse them each time they are used. (to be verified.)
| |
