hi all,
my need is to add identity constraints to existing column of table
thanks .
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Apr 4, 2013, 6:30 AM
http://blog.sqlauthority.com/2009/05/03/sql-server-add-or-remove-identity-property-on-column/
Pankaj RawatPosted Apr 4, 2013, 6:23 AM
so the possible solution is:-
a). Either Create a new table with Same Fields and Structure and apply identity to the column at that time and then drop the previous table.
b). Create a new Column with same Datatype and Apply Identity to it and then delete the Column(previous).