Add an unique id field in an existing table

[mbwmbk]

I have a table with 100 rows. I need to add a unique id field to identify each row in the that table. How can I do that?

 

[synapsevampire]

In Enterprise Manager, add a field of type Int and select Identity = Yes, it should create the column and populate it.

SQL Server 2000

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[BG12424]

Use an alter table command then specify the IDENTITY attribute.

alter table << tablename >> add column << fieldname >> int not null identity _______________________________
regards,
Brian

AOL IM: FreelanceGaines