Would like option for compare table to rename columns instead of Alter Drop and Alter Add
説明
Attempting to generate alter table script by comparing two tables in two different schemas on the same db instance, using database | compare |single objects. Currently the script is generating Drop and Alter Add column script. Is it possible to generate a script to rename the columns instead of dropping and adding the columns?
原因
Toad cannot determine which columns match up to be renamed so an Alter Table Drop and Alter Table Add is necessary
