Problem with Alter Column! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem with Alter Column!

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
Go But the identity property remains ‘Yes’. How can I change it through tsql script?

Hi,<br />please refer BOL for Alter table statements<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
or Do it in Enterprise Manager and Click save Change Scipt and see the code Madhivanan Failing to plan is Planning to fail
If your tables are fairly large, consider saving the script generated by EM and run it as a job during off-peak hours. —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?