Archives of the TeradataForum

Message Posted: Thu, 12 Dec 2002 @ 13:49:49 GMT

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

Why not just use

CREATE TABLE AS new tablename(
SELECT
        A.OLD DATA COLUMNS
        ,(CASE STATEMENT HANDLING THE DEFAULT) AS NEW DATA COLUMN
FROM
        OLDTABLE A
)
WITH DATA;
SAME INDEX AS OLD TABLE

Make sure not to REDISTRIBUTE the rows in the new table by maintaining the original index the rows are distributed on.

Kevin Lynch
K M L Consulting

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