Subject | Change pri key data type to auto increment |
---|---|
Author | jwcane2003 |
Post date | 2012-06-14T19:36:51Z |
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?
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?