Renaming Primary Keys and Foreign Keys in a One-to-Many Relationship Without Breaking Constraints

Resolving the Error: Can't DROP COLUMN in MS SQL with MS SQL Constraints