Archives of the TeradataForum

Message Posted: Thu, 16 Aug 2007 @ 11:12:19 GMT

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

Vinay,

Thanks for the stored procedure.

When creating the copy of the view, is there any way of determining the database and table that the view is using? i.e. View VW1 does a select * from DB1.TAB1, so I need to make my copy of the view use DB1.TAB1 also.

Regards,

Martin

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