Changing or re-creating primary key columns

You can change the primary key columns without restriction if either of the following conditions are true:

• The table uses ERKEY shadow columns or another unique index or constraint as the replication key.
• The primary key contains multiple columns. The column modification implicitly re-creates the primary key.

To change a primary key column if the primary key is a single column, enclose the primary key column modification and the primary key recreation operations in a single transaction. If you frequently update a primary key that is a single column, consider changing the replication key to another unique index or constraint.