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 |
|
royv
Constraint Violating Yak Guru
455 Posts |
 Posted - 2002-04-29 : 18:33:11
|
| I'm on SQL Server 7 SP3.Can you alter a column to have an IDENTITY? This is what I have tried:alter table tblWhateveralter column idcol int identity(1,1) not null*************************Just trying to get things done |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-29 : 18:39:52
|
| Don't think so. You can add a colum that is Identity though.ALTER TABLE tblWhatever ADD idcol INT IDENTITY(1,1) not null-Chad |
 |
|
|
|
|
|
ALTER COLUMN