1. SQL Reference Guide
  2. Data Row Management
  3. UPDATE Statement
  4. Updating rows with an IDENTITY Column

Updating rows with an IDENTITY Column

An IDENTITY column that is defined as GENERATED ALWAYS cannot be updated. Only IDENTITY column that is defined as GENERATED BY DEFAULT can be updated.