How to Add an Auto-Increment Field With a Unique Name

[linhtv]

Hi every body!

I have a code:

ALTER TABLE archive ADD ID int IDENTITY(1,1) PRIMARY KEY

but when i running, i'm alway get an error:

Column names in each table must be unique. Column name 'ID' in table 'archive' is specified more than once.
 

So how to fix this problem.

Thanks all for help me!

[yarbrough40]

Naming your column something else should do the trick ( that error message is not all that cryptic)

[ck9663]

It means you already have a column named ID in your table. Use another name.

Happy Coding!!!


~~ CK