When i delete column from table, related script is generated badly.
Example:
When i delete column X from table SCH_ADDRESS.TBL_POST
-- Drop columns
alter table SCH_ADDRESS.TBL_POST drop column X;
-- Create/Recreate primary, unique and foreign key constraints
alter table SCH_ADDRESS.TBL_POST
drop constraint FK_POST_X;
alter table SCH_ADDRESS.TBL_POST
add constraint FK_POST_X foreign key ()
references SCH_ADDRESS.TBL_POST (GUID);
Example:
When i delete column X from table SCH_ADDRESS.TBL_POST
-- Drop columns
alter table SCH_ADDRESS.TBL_POST drop column X;
-- Create/Recreate primary, unique and foreign key constraints
alter table SCH_ADDRESS.TBL_POST
drop constraint FK_POST_X;
alter table SCH_ADDRESS.TBL_POST
add constraint FK_POST_X foreign key ()
references SCH_ADDRESS.TBL_POST (GUID);