Toad World® Forums

Alter table script appears incomplete


The script I just generated to change a table doesn’t migrate the data properly.
The part of the script that moves the data to a tmp table is just putting nulls
or default values (like using getdate()) into the table. It also doesn’t use
“set identity_insert” to preserve the identity column values.