Thank you for your help but the answer that i needed was this so i help it helps someone else.

alter table yourtable

add autonumber int identity(1,1)

go