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 MyTableAlter 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
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
]]>