alter table

[tiger66]

HI I am trying to change one of my database field to auto_increment.
I am getting an "invalid alter table option" when I tried to alter my table with code below

alter table PC modify ID NUMBER(10) AUTO_INCREMENT NOT NULL

Please help

Thanks

[bloke]

What type of database are you using?