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,03 sec, rows selected: 12, rows affected: 20, absolute service time: 0,19 sec

fork mode | history

  
ssn
firstname
id

1
111111
Jeff
1

2
123456
Kevin
2

3
654321
Mark
4

4
555555
David
3


  
ssn
firstname
Id

1
111111
Jeff
1

2
123456
Kevin
2

3
654321
Mark
4

4
555555
David
3


  
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