Archives of the TeradataForum

Message Posted: Tue, 16 Jan 2007 @ 14:01:43 GMT

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

<-- Anonymously Posted: Tuesday, January 16, 2007 08:39 -->

Since Teradata uses "late binding" based on name and not internal ID like some other databases, the DBMS doesn't know or care if the view is "valid" until it tries to parse and resolve a query. So you have to do something such as

     EXPLAIN SELECT * FROM MYVIEW;

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