That's right! Do you want to be able to alter any of the IDENTITY properties for a column in SQL server? Well, you've come to the right place, boy-o (or girl-o).

You can't. At least not directly. If you've read the MSDN documentation, you might be lead to believe you can, but closer inspection will tell you that you've been hoodwinked. You see, that's the documentation for SQL Server Mobile edition only.

The real answer?...




... you have to do the old create-copy-drop-rename scenario. Create a new table with a different name with the new schema, copy the data from the existing table into the new one, drop the old one, then rename the new one. All of this taking into account the indexes and relations on the table. Mmmm. Delicious.