How to create an Autonumber field in SQL Server 2012

Same as it was in the last version.

The task can either be performed through the Server Management Studio designer to code

In the designer,

  • select the field
  • ensure it’s an int
  • Set the Column Properties as IsIdentity

 

Or through code

ALTER TABLE [tableName] DROP COLUMN ID 
ALTER TABLE [tableName] ADD ID INT IDENTITY(1,1)

David Gregory Medina

Post created by: David Gregory Medina

Leave a Reply