Thursday, September 4, 2008

How to add identity to the existing sql server 2000 table?

ALTER TABLE Foo
ALTER COLUMN FooKey
ADD CONSTRAINT IDENTITY(100,1)

No comments:

 
Feedback Form