Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I change identity property in SQL Server 2008?

I have a table which has no identity column. I want to change a column's identity specification, but SQL Server 2008 doesn't allow that. So, how can I change identity property in SQL Server 2008?

like image 578
cagin Avatar asked Dec 04 '22 15:12

cagin


1 Answers

under tools-->options-->designers-->table and database designers

uncheck prevent saving changes that require table re-creation

like image 72
SQLMenace Avatar answered Jan 06 '23 05:01

SQLMenace