SQL: Change a datatype updating all PKs and FKs

We had a global change of one of our fields here at work that is used in about 5000 tables.  It needed to be changed from a varchar(4) to a varchar(10).  The challenge was all the data integrity issues, so I wrote up this script to allow us to change the datatypes.  It gets the [...]

Continue reading about SQL: Change a datatype updating all PKs and FKs