<div>
You want to update an identity column? Be careful with updating a primary key column since it can affect the referential integrity. You'll need first to disable the constraint before updating the field.
</div>


<div>
This is a test database so not a huge deal
</div>


<div>
Assuming this would work you could change a column to identity only if its data type is int/bigint however I think the SSMS change will not work and it will generate an error when you will hit the save button.
</div>


<div>
<div class="content wysiwyg-content">
i have a primary key field -- but how do i update the field so that it is is an identity column that increments by one every time something is inserted.<br />
<br />
It is an existing table so i believe I have to use alter table but not sure of all the syntax
</div>
</div>


i have a primary key field -- but how do i update the field so that it is is an identity column that increments by one every time something is inserted.

It is an existing table so i believe I have to use alter table but not sure of all the syntax

You want to update an identity column? Be careful with updating a primary key column since it can affect the referential integrity. You&#39;ll need first to disable the constraint before updating the field.

This is a test database so not a huge deal

Assuming this would work you could change a column to identity only if its data type is int/bigint however I think the SSMS change will not work and it will generate an error when you will hit the save button.

i have a primary key field -- but how do i update the field so that it is is an identity column that increments by one every time something is inserted

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.