Auto increment primary key in SQL Server Management Studio 2012

by

Make sure that the Key column’s datatype is int and then setting identity manually, as image shows

enter image description here

Or just run this code

-- ID is the name of the  [to be] identity column
ALTER TABLE [yourTable] DROP COLUMN ID 
ALTER TABLE [yourTable] ADD ID INT IDENTITY(1,1)

the code will run, if ID is not the only column in the table

image reference fifo’s

More Related Contents:

  1. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  2. LocalDB deployment on client PC
  3. How to check if a column exists in a SQL Server table
  4. SQL Server, How to set auto increment after creating a table without data loss?
  5. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  6. How to change identity column values programmatically?
  7. XML Server XML performance optimization
  8. Adding a query hint when calling Table-Valued Function
  9. How to enable bulk permission in SQL Server
  10. Sequence as default value for a column
  11. Why the SQL Server ignore the empty space at the end automatically?
  12. Last executed queries for a specific database
  13. Avg of float inconsistency
  14. Dynamically assign filename to excel connection string
  15. SQL Server Configuration Manager cannot be found
  16. SQLServer IDENTITY Column with text
  17. Joining multiple tables returns NULL value
  18. Is it possible to use user defined aggregates (clr) with window functions (over)?
  19. How to pivot unknown number of columns & no aggregate in SQL Server?
  20. “No backupset selected to be restored” SQL Server 2012
  21. Restore a SQL Server 2000 backup on SQL Server 2012
  22. Datatype for storing ip address in SQL Server
  23. SQL Server: Query fast, but slow from procedure
  24. What columns generally make good indexes?
  25. What is a free tool to compare two SQL Server Databases? [closed]
  26. SQL Server Management Studio alternatives to browse/edit tables and run queries [closed]
  27. #DELETE viewing SQL Server table in Access
  28. SQL Server (localdb)\v11.0 explained
  29. SQL Server – join rows into comma separated list
  30. How to do Sql Server CE table update from another table

Leave a Comment