Yes, but in practice it frequently happens that you refer to records in various different places. Either client-side in API-using software, or in a completely s

Yes, but in practice it frequently happens that you refer to records in various different places. Either client-side in API-using software, or in a completely separate database, etc. In such cases, "Update all references in the world" will be entirely impractical and bug-prone.