Deleting columns from table

Mozart

Member
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);
 
Back
Top