First I am using Toad for SQL Server v6.5.0.3282 freeware (as I know latest version nowadays). Today I tried to alter my Orders table and toad remove all foreign key from that table. My opinuon is; when I tried to add a column to table from Toad script removes CONSTRAINT but then script should create that CONSTRAINTs again but I didn’t saw that script at alter table pop-up’s script tab.
did you ever get an answer for this? I have same issue - thought I was going crazy when foreign keys pointing to the altered table were deleted - other developers told me TOAD was doing it only I didn’t believe them, but alas, it is so. back to using sql management studio