how to add identity column for existing table

See more:

SQL-Server

Hi Everyone,


I have created a table Tracks.while creating the table i forget to give identity constraint.

now i am altering the column. it is showing error:incorret syntax near the key word identity.

here is my query:

alter table albums alter column albumid bigint identity(1,1).

can anyone tell me how to do this.