Hello,
I have a SQL CE 3.5 database table having 35000 records. like
Code:
Name  Age Sex
abul     21    M
babul   22    M
cabul   23    F
.......................
zabul   23    M

I want to add an Auto_increment (Identity) Primary Key 'Id'

Code:
Id          Name Age Sex
1           abul     21    M
2           babul   22    M
3           cabul   23    F
.....................................
35000     zabul   23    M
what will be the query?

Thanks