Not sure why but I can't seem to figure out how to make an integer column an identity AFTER the table has been created.

I have tried this:

ALTER TABLE Table1
ALTER COLUMN Column1 int IDENTITY NOT NULL
GO

And various iterations. No luck. Maybe i'm just a bit foggy due to the long weekend, but does anyone know how this is done?

Thanks...

Scott

__________________
========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================

Try this:
ALTER TABLE Table1
ALTER COLUMN Column1 int NOT NULL IDENTITY

I get:

Incorrect syntax near the keyword 'IDENTITY'

what version of sql server are you using? I tried this on SQL Server 2005 and didn't get an error. Are you using sql express?

If you have data on your table, you must give it a starting value and an increment value. For instance if you have numbers up to 1000 and you want to increment by 1 you do this:

Identity (1000,1)



Sal

Yes, you have been missing the Identity seed and increment values... That is why you have not been getting it right.

Cheers.

_________________________
- Vijay G
Strive for Perfection