Toad is always trying to drop table when adding a column with not null.
The issue is that when an alter table is performed, Toad is creating the script with drop table. It's possible write script with ALTER TABLE ADD COLUMN ... NOT NULL DEFAULT '';
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center