Mention what are the limitations of IDENTITY column?

Technology CommunityCategory: T-SQLMention what are the limitations of IDENTITY column?
VietMX Staff asked 4 years ago

The limitations of the IDENTITY column is that column values cannot be updated once generated. Also, it may require to specify this column as a PRIMARY KEY, as such, there is a possibility of duplication of values within a table. Identity property is applicable for integer based column only.