Hi, I'm asking for some help for changing the primary key of a table that has more than 1000000 records.
The idea is to create a new INTEGER column that will contain a generated sequence by combining a generator and a trigger that is going to be the primary key. So I have to get this goal: Once created the new INTEGER column, I must populate all records with the sequence of numbers before adding the constraint for defining the primary key. Is there any SQL comand that I can run for doing this. Maibe a stored procedure or Firebird function? Any help will be appreciated. Regards, Hernando.
