Archives of the TeradataForum

Message Posted: Fri, 19 Nov 2004 @ 16:37:07 GMT

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

Ed,

Create a simple view with only the original columns from the previous version of the table. You'll have to rename the table to something different and give the old tablename to the view. One caveat - the new column will always be null unless you set a default value.

Hope this helps,

Jonathan

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