I have a field in my table that is an identity field. I have to write script to set the identity property to 'NO'.
I tried this
Alter Table MyTable
Alter Column MyColumn Int Not Null
But the identity property remains 'Yes'. How can I change it through tsql script?