Theres been a lot of talk about:
'slapping on identity columns'

Very well, now I slapped an integer column
on my table. How do i fill it up with consecutive
numbers using sql?

(I'd rather not move all data to a new table
with a generated column, and you can't set
the column to autogeneration if you slap it on
after table creation)

Cheers

Code:

ALTER TABLE YourTbl 
ADD COLUMN YOURNR INTEGER 
GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 );

I'm afraid that doesn't
work on existing tables