 It is a common misconception that an identity column will enforce uniqueness; however, this is not the case.If you want to enforce uniqueness on the column you must include the appropriate constraint too.In Microsoft SQL Server you have options for both the seed (starting value) and the increment.