Archives of the TeradataForum

Message Posted: Thu, 09 Jul 2009 @ 16:19:34 GMT

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

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

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