Procedure would be:1) drop PK/FK (either using checkbox or using pre/post script)2) mask PK column and all FK columns in other tables using the same deterministic uniqueness preserving algorithm.3) recreate PK/FKSome details to be aware of:
As you drop the PK the logic needs another logical key to identify the rows. On Oracle we would always advise to use ROWID.
On MSSQL add a temporary column of type identity and set that name in logical key.
Use SM or SM_UNI (algorithm must be deterministic and uniqueness preserving) - those algorithms do that BUT they guarantee the unique result but not the uniqueness during the process.Last not least the most important question: Does the PK contain sensitive information like Name, DOB,SSN ? If not - no need to mask ;)