[ Attachment(s) from Hank_Freeman(msn) included below]
When trying to generate an Alter statement on a table, it was noticed that
Toad-SS did not find or manage all the constraints. Therefore when it want to
re-create the constraints it came up way short.
Objective: Change two fields from char to varchar in App.Landlordagreements
Problem: Completely different code generated by SSMS and Toad-SS to make this
ALTER change.
Area of concern: Toad-SS not finding all the needed constraints on target table
thus NOT generating all the needed drops and adds
Conclusion: Alter on Toad-SS 5.5 doesn’t generate the correct information
about a table so as to make a proper Alter on a table. Making this functionality
in Toad-SS unusable .
This is especially poignant one looks at the two Table view details between SSMS
and Toad-SS 5.5
See attached document for full details.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
Attachment(s) from Hank_Freeman(msn)
1 of 1 File(s)
TOAD-SS_Alter_Missing-Contraints.docx
