Subject Change a PK field from text to autonumber
Author capitansigfrido
Hy, I need to change the PK in a table from string to numeric.
A crated a new field called "id" and I made a new generator for this

I have about 2k of records in this table. I usually use a code made in
VB to fill this new field with secuential numbers, and after that,
activate the trigger to use the generator.

Because I havenĀ“t much experience in SQL programing, I need for someone
to explain me how I can use a procedure to do that with SQL code.
That is, update avery record of the field with a secuential number for
the field "id".