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 |
|
hendrasd
Starting Member
20 Posts |
 Posted - 2003-07-06 : 21:56:18
|
| I tried to alter an identity column in a table with the following code :ALTER TABLE TCobaALTER COLUMN Id int identity(1000,1) not for replicationgoBut I kept receiving the following error message :Incorrect syntax near the keyword 'identity'.What is wrong with the code ? How to alter identity column using T-SQL Code ?Thanks in advance ...-- Never stop learning --Edited by - hendrasd on 07/06/2003 23:28:44 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-06 : 22:46:50
|
| try it with a datatype.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
hendrasd
Starting Member
20 Posts |
Posted - 2003-07-06 : 23:30:18
|
sorry my mistake ... but still it doesnt work if I included the integer datatype ...quote:
try it with a datatype.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
-- Never stop learning -- |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-07 : 02:01:38
|
| You can alter the datatype but not the seed or turn it into an identity.To change the seed use dbcc checkident==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Altering Identity Column