Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
add uniqueidentifier field to existing table
- Thread starter Lost500
- Start date
mutley1
MIS
- Jul 24, 2003
- 909
Something like an identity seed would do the trick.
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
Code:
ALTER TABLE MyTbl ADD [newcolname] [int] IDENTITY (1, 1) NOT NULLThis 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
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question