Archives of the TeradataForum

Message Posted: Fri, 21 Oct 2005 @ 09:03:47 GMT

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

If you have sufficient space for two copies, create the table as multiset, Insert select the data from the set table to the multiset table, drop the set table and rename the multiset table.

That is the easiest way to do it. It will save you any effort that might be involved in "recreating it".

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