Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2006 @ 09:10:22 GMT

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

Certainly for Teradata - using Erwin 4.1.4 - it will bring them in and link them together as long as the View specifically names the columns from the table. If, as in our environment, the View matches the table exactly using a wildcard construct:

     REPLACE  VIEW DEVCE_V.TIMEZONE_V01 AS
           SELECT *
           FROM DEVCE_T.TIMEZONE

then it will NOTdefine the columns in the imported table - unfortunately.

_______________________
Dave Clough
Database Designer
Express ICS

www.tnt.com

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