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

ALTERING A PRIMARY KEY COLUMN WITHOUT DOWNTIME OR LOCK TABLE: EXPLORE YOUR OPTIONS