Canging the value of a primary key that is referenced by foreign keys in other tables

I want to change galleries.projectId which is in relations with files.projectId, is there a way to do this?