Archives of the TeradataForum
Message Posted: Thu, 09 Jul 2009 @ 16:19:34 GMT
Subj: | | Re: Drop column from view |
|
From: | | Curley, David |
Remember also that replace view keeps existing grants in place, so you don't have to restore them as you would with drop + create.
Kind of related to this, I just noticed something interesting in the DDL SQL reference manual:
"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.
Dave
|