add uniqueidentifier field to existing table

[Lost500]

hey guys and gals,

is there a way to add a uniqueidentifier field to an existing table that already has data in it.

 

[mutley1]

Something like an identity seed would do the trick.

ALTER TABLE MyTbl ADD [newcolname] [int] IDENTITY (1, 1) NOT NULL

This should populate what is already there with an ideltity as well so it's up to date. Test first though, then test adding a row after to make sure continuity of the seed is correct as I haven't tested the whole thing.

HTH,

M