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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-06 : 09:36:01
|
Manikandan writes "Hi
We are using WIN NT with SQlserver 2000. We have a table called postalzone. It has several columns and the column postalnumber is the primary key. datatype numeric(9,0)...We have lakhs of records in the table. Now we have a requirement to make this column also as identity column. I am able to do this via enterprise manager. (design table - > identity drop down -> select 'Yes'). So i probably thought it should also be via a sql statement. But i am not successful until now. There is no provision for that in alter table statement.(There can be gaps in the numbers also.) I am soliciting your help on the same.
cheers
Manikandan" |
|
|
|
|
|
Modifying a column as identity column