Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2014 @ 15:41:00 GMT

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

You can follow this procedure:

1) Create new table with same structure as existing, but:
Make the table multiset
Make the identity column "GENERATED BY DEFAULT"

2) Insert data into new table - include the identity column value from original.
BY DEFAULT will accept the keys for rows you already have, and will
generate new ID's for new rows.

Erich Fischer
BI Sr. Consultant

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