Sean Pearce (5/20/2014)
What do you mean?Change the column that is an IDENTITY?
Add or remove an IDENTITY column?
Change the seed?
There is an Identity Property for a column it is set to True or False.
You can't change it from falsetto true.
You can change it in design mode from True to false but how do you do this in T-SQL Code.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/