How to set a table's field to autonumber using a query in sql, Sql Server

How to set a table's field to autonumber using a query in sql

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 4, rows affected: 8, absolute service time: 0,16 sec

latest | history

  
ssn
firstname
Id

1
111111
Jeff
1

2
123456
Kevin
2

3
654321
Mark
4

4
555555
David
3

λ

                                      .NET NoSQL database for rapid development