Sql server limitations of IDENTITY Column
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