Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2026 03:06 AM
Potential risks of identity columns are:
- Concurrent writes are not allowed. That is, if multiple flows write to the table with generated identity columns, they will either run sequentially or fail on conflict.
- There is a slight overhead when inserting values into the table with identity columns.
Yes you can put identity column into the TRACK HISTORY ON parameter.
Best regards,