Alter table on identity column

Database

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
N/A

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.