Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Alter script to add identity property

Author  Topic 

learntsql

524 Posts

Posted - 2010-10-20 : 09:58:21
Hi All,
How to generate alter table script to add identity property for existing column on a table.
Plz..

TIA.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-20 : 10:45:59
No way of using just alter table.
See here:
http://www.sqlteam.com/search.aspx?cx=011171816663894899992%3Aaow51lf_dim&cof=FORID%3A9&q=alter+table+identity#1142


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

learntsql

524 Posts

Posted - 2010-10-21 : 00:31:10
ThankQ..
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-21 : 02:23:44
welcome


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -