Subject Change pri key data type to auto increment
Author jwcane2003
I created my tables without specifying automatic numbering (incrementing) of key fields (type integer). I now want to go back and fix that. Here is what I am using in IB_SQL:

alter table units alter column kunit auto_number primary key

IB does not like the data type. Literature refers to autonumber and auto_increment. Those don't work either.

How is this done?