Return
-
Title
Toad is not generating a correct script when altering a table to drop a column -
Description
When altering a DB2 table in Toad to drop a column, Toad generates a script utilizing the Unload tool. However, Toad generates the script so that it unloads all columns (even the column being dropped), then drops the table, and finally loads the data with the non-existant column.
NOTE: In the Toad options, the option "Use commands/utilities" for the Preserve Data Method is selected for this scenario.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.