Alter table on identity column

Database
New Member

Alter table on identity column

Does any one know if we can alter table on identity column from default NO CYCLE to CYCLE? If yes, what's the syntax of that? Thanks.
1 REPLY
Enthusiast

Re: Alter table on identity column

I don't think you can alter an Identify column. I think you'll have to drop and recreate the table. If you do, just the generate by default option so you can populate the existing rows in the new table.