Sql server limitations of IDENTITY Column

Published on by LakshmiSaahul,Dhana Royal

What are limitations of IDENTITY Column?
IDENTITY column can be used as a surrogate key. This column values cannot be updated once generated (automatically or manually). As we have possibility to duplicate these values within a table we may require to define this column explicitly as a PRIMARY KEY. This Identity property is applicable for integer based columns only. /p>

Advertising
To be informed of the latest articles, subscribe:
Comment on this post