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.
| Author |
Topic |
|
rowter
Yak Posting Veteran
76 Posts |
 Posted - 2009-09-30 : 09:55:36
|
| I have a table whose column property i have to change.I hav to set the identity specificationto yes and Identity incremnt and identity seed to 1.How can i do this?In the sql server management studio when i right click on the table and open the design, i tried to change there but it is not allowing me to change.Thanks in advance |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-09-30 : 10:15:58
|
| You'd have to make a copy of the table, truncate the old one and then make the changes to it, and then reinsert using the table copy. This will renumber all the identities, starting at 1.JimEveryday I learn something that somebody else already knew |
 |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2009-09-30 : 11:11:44
|
Never worked on database and do not want to mess with it.  Is this the only way to do it? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 01:46:16
|
| http://www.mssqltips.com/tip.asp?tip=1397 |
|
|
|
|
|
|
Change the column properties of a table